I am happy to report - this worked! Took some rejigging afterwards for Reports & Forms, but I think it is all good now. Thank you!!
On Thursday, April 17, 2025 at 4:52:21 PM UTC-7 randyp ctags.com wrote: > 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]. > 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]. > 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/7db89a39-5091-447b-9aa4-d3d11d944fban%40googlegroups.com.
