Thanks everyone for chirping in. I found my problem.
I have a button on this form that brings up another form.
Closewindow did not work and the second form covered up the first form so I
didn't realize it was still active.
I don't understand how any variables in the first form could affect vars in
the second form but eliminating the first form seemed to fix the problem.
Bernie Lis
----- 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
