An RBase 32 bit Integer is just a little short of the standard at 1,999,999,999. (Look in Help>Index> "Data Types" for the capacity of all RBase Data Types
Well above your number of 970000. When I do: Set var OrdNo integer = 970115 set var OrdNo = (.OrdNo + 1) I get 970116 as expected. Look into the value actually returned by your select. I notice there was no where clause. Is that because there is only one row. Also, when things are behaving in ways they absolutely shouldn't, I do a full ReBoot to start with a "Clean Slate", just to give me peace of mind. ----- Original Message ----- From: "Bernard Lis" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, April 10, 2008 10:38 PM Subject: [RBASE-L] - integer value > 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 > > >
