Without knowing your rbase version, code, structure, etc, it's hard to recommend something. But something to recommend out of the air, is convert that unique REAL column to a TEXT or a BIGNUM column.
Robert ________________________________ From: [email protected] <[email protected]> on behalf of Lin MacDonald <[email protected]> Sent: Thursday, April 17, 2025 2:20 PM To: [email protected] <[email protected]> Subject: [RBASE-L] - Data type question 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>. ________________________________ From: [email protected] <[email protected]> on behalf of Lin MacDonald <[email protected]> Sent: Thursday, April 17, 2025 2:20 PM To: [email protected] <[email protected]> Subject: [RBASE-L] - Data type question 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]. To view this discussion visit https://groups.google.com/d/msgid/rbase-l/SA1PR19MB51820469DE4FC2DB640DE84BA8BC2%40SA1PR19MB5182.namprd19.prod.outlook.com.
