Bernie, Following is from www.rsyntax.com. Datatype reference
"INTEGER · Holds whole numbers in the range of ±1,999,999,999 · Delimiters (such as commas) cannot be used in entry · R:BASE reserves four bytes of internal storage space" Make sure you value is truly defined as an integer. Also make sure that no other part of you code such as RULES, STORED PROCEDURES defines a limit on max value. What is the datatype for "orderno" in the table. insert "SHO VAR ordno" into your code to see what data type RBase has assigned. To the best of my knowledge the datatype could be overridden by the select into statement. --- Bernard Lis <[EMAIL PROTECTED]> wrote: > Hello Experts, > > I have an integer column whose value has become greater than > 970,000 > This is the value of our Order Number > So far no problems have been discovered using this number. > I was under the impression that the max integer is 32,767 > > But today I tried to add one to the order number and the order > number did > not change. i.e. set var OrdNo = (.OrdNo + 1) > > Here is my code: > set trace on > set var OrdNo int=null > sel orderno into OrdNo from dbcontrol I get 970115 > set var OrdNo = (.OrdNo + 1) Ordno still is 970115 > > Then I did this > set trace on > set var OrdNo int=null > sel orderno into OrdNo from dbcontrol I get 970115 > set var OrdNo = (.OrdNo + 1) Ordno still is 970115 > set var OrdNo = (.OrdNo + 1) Ordno doesn't change > > Anybody have a GhostBuster team? > > Bernie Lis > > > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
