Nick is right -- convert it to Double.  Unfortunately, there are really really 
old versions of RBase that didn't even have Double as an option.  Real was all 
we had that allowed a decimal point

Karen


    On Thursday, April 17, 2025 at 02:24:09 PM CDT, 'Nicky Avery' via RBASE-L 
<[email protected]> wrote:   

  
 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 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].
 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 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].
 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.
  

-- 
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/662269843.2593199.1744919121885%40mail.yahoo.com.

Reply via email to