Try DOUBLE?
Nicky
On 4/17/2025 11:39 AM, rdiaz
kcnyenterprises.com wrote:
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 questionI 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.
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 questionI 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.
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.
--
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/ae96992f-55a9-4ba3-9826-eafb4bbfbd4a%40wwavs.com.
