Create a new Column with a better data type. Add it to your other tables that are linked and needed. Make it unique and autonumber. then slowly begin to make those columns be your new Keys. Get rid of your older columns.
________________________________ From: [email protected] <[email protected]> on behalf of randyp ctags.com <[email protected]> Sent: Thursday, April 17, 2025 7:52 PM To: [email protected] <[email protected]> Subject: Re: [RBASE-L] - Data type question Rename Column in every table except one. Use a name like Column1. Change the data type of the one remaining column. Rename each of the others from Column1 back to Column. It will change them to the new data type. You may need to do this in the Database Explorer where columns are defined. Will this lose the key structure and form and report connections? ________________________________ From: [email protected] <[email protected]> on behalf of Lin MacDonald <[email protected]> Sent: Thursday, April 17, 2025 6:07 PM To: [email protected] <[email protected]> Subject: Re: [RBASE-L] - Data type question Sadly, it won't let me convert to any other type because it is tied to so many tables. And, it was initially started on R:Base System V, LOL! Currently running v. 10.5 On Thu, Apr 17, 2025, at 11:20 AM, Lin MacDonald wrote: I have a very old system. I began writing it in 1988 and have been adding to it ever since. It has been so long that I don't remember how I set most of it up! One of my Unique keys tying several tables together is a Real data type. It will not let me enter more than 7 numbers (i.e. 9999999 or 9999.999) I really need to be able to make it something like 9999999.9. So, add a decimal point and 1 number. Is there any way to do that or am I stuck with this length? thanks, Lin -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/0eb5c4ea-b662-49b9-b028-61a720930893%40app.fastmail.com<https://groups.google.com/d/msgid/rbase-l/0eb5c4ea-b662-49b9-b028-61a720930893%40app.fastmail.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/3778bc6d-024b-48ca-86cb-56f2cdb5a2e5%40app.fastmail.com<https://groups.google.com/d/msgid/rbase-l/3778bc6d-024b-48ca-86cb-56f2cdb5a2e5%40app.fastmail.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/PH0PR11MB5112E99CC8C75236F98E145CC7BC2%40PH0PR11MB5112.namprd11.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/PH0PR11MB5112E99CC8C75236F98E145CC7BC2%40PH0PR11MB5112.namprd11.prod.outlook.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/SA1PR19MB51822F18D13C0F87FD383A9CA8BF2%40SA1PR19MB5182.namprd19.prod.outlook.com.
