Frank, Embed the code in a form and password protect the form!
> -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Frank > LaVolpa > Sent: Wednesday, March 16, 2005 12:29 PM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Just show the first record in the table? > > Nevermind!! I figured it out. Woot! Apparently an associate decided > they didn't like my logic and changed a few things.. Grrrrrrrrr > > --Frank > > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Frank > LaVolpa > Sent: Wednesday, March 16, 2005 11:08 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - RE: Just show the first record in the table? > > > Can someone tell me what's causing the error in this set of lines? This > used to work. I don't know what changed. > > The error is: -ERROR- (31) is a reserved word or contains illegal > characters. (3065) > > The code is: > ------------ > set quotes = ' > Set var exportMonth text='' > Set var exportYear text='' > Set var exportEOM text='' > set var startDate text='' > set var endDate text='' > > disconnect > connect ship.rb1 > > cls > fillin exportMonth using 'Do the Alltel Export for what month (1-12)? ' > at 10,10 > fillin exportYear using 'Do the Alltel Export for what year (YYYY)? ' > at 10,11 > > if float(.exportMonth)<1 or float(.exportMonth)>12 then > write 'The Month specified is invalid.' > disconnect > end > endif > > Set var exportEOM = '31' > > if float(.exportmonth)=2 then > set var .exportEOM = '28' > endif > > if (mod(float(.exportyear),4))=0 and float(.exportmonth)=2 then > set var .exportEOM = '29' > endif > > if float(.exportmonth)=1 or + > float(.exportmonth)=3 or + > float(.exportmonth)=5 or + > float(.exportmonth)=7 or + > float(.exportmonth)=8 or + > float(.exportmonth)=10 or + > float(.exportmonth)=12 then > set var .exportEOM = '31' > endif > > if float(.exportYear)<1900 and float(.exportYear)>2100 then > write 'The Year specified seems invalid. Must be between 1900-2100.' > disconnect > end > endif > > if float(.exportMonth)>=1 and float(.exportMonth)<=9 then > set var exportMonth = '0' + .exportMonth > Endif > -------------- > > Thanks! > --Frank
