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
