Razzak, Thanks for the QUICK response. >From your example I learned more about:
SELECT INTO & INDICATOR It is certainly easier than using COMPUTE. You may get me switched over to Windows yet. And yes, I've not graduated to leave FILLIN yet. Thanks again, Ned Ritchie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of A. Razzak Memon Sent: Tuesday, October 02, 2001 6:26 PM To: [EMAIL PROTECTED] Subject: Re: Possibility to Increment by only 1? - Razzak's Reply At 05:46 PM 10/2/01 -0700, Ned Ritchie wrote: > >... Just upgraded to 6.5++ to use the DWRD feature to print >some checks that I usually do by hand. > >HOWEVER. . .I cannot get the check number to increment correctly. Ned, I would create an expression to increment check numbers by 1. Example: 01. Launch The Glorious R:BASE 2000 (ver 6.5++) for Windows At the mighty R> prompt: 02. CONNECT DBName 03. SET VAR vCheckNumb INTEGER = 0 04. REPORT ReportName (to Launch Report Designer) Click on Variables > Edit vCheckNumb = (.vCheckNumb +1) Click on Add (By default that should be defined for Detail Section) 05. Locate vCheckNumb variable accordingly 06. Save Report 07. In a command file or at the R> prompt: CLEAR ALL VAR SET VAR vCheckNumb INTEGER = 0 SELECT (MAX(CheckNumb)) INTO vCheckNumb INDIC IvCheckNumb + FROM Tablename PRINT ReportName WHERE ... ORDER BY ... or OUTP PRINTER PRINT ReportName WHERE ... ORDER BY ... OUTP SCREEN Hope that helps! If you need more help, feel free to ask. Enjoy and make sure to have fun. Very Best Regards, Razzak. ===================================-============================ Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase2000.com/events R:DCC Members: http://www.rbase2000.com/rdcc ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-=============================
