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]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/PH0PR11MB5112E99CC8C75236F98E145CC7BC2%40PH0PR11MB5112.namprd11.prod.outlook.com.
