Bernie, I cannot tell you what your issue is, but the max integer is certainly much larger than that ... it is around 4,294,967,295 or so, the largest value you can represent with 4 bytes.
Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Thursday, April 10, 2008 10:39 PM To: RBASE-L Mailing List 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
