Variables in R:BASE are by nature global. If you want to have "local" variables, you have to "localize" them by using prefixes that pertain to a given form or procedure. For instance, by default I start variables with the letter 'v', but in stored procedures will start them with 'p' or 'p' and 'r' (in an update trigger, for 'prior' and 'revised') so that I can "CLEAR VAR p%' and not impact my form or calling command file.
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: Saturday, April 12, 2008 8:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: integer value 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 > > >
