Karen,
Thank you. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, May 11, 2011 2:37 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: cancel button within WHILE Jim: Here's selected pieces of the code I use for this: SET VAR vTID text = null DIALOG 'Enter last CustID that printed correctly' vTID vendkey 1 CAPTION 'or leave BLANK to print all' IF vTID IS NULL THEN SET VAR vWhere = ('CustID IS NOT NULL') ELSE SET VAR vWhere = ('CustID > ' & .vTID) ENDIF DECLARE c1 CURSOR FOR SELECT CustID FROM yourtablename WHERE &vWhere ORDER BY custid -- what follows is your normal print code Karen In a message dated 5/11/2011 1:10:39 PM Central Daylight Time, [email protected] writes: That code may be something I ca use in other areas. Please send it. I am always looking for ways to make the code better to meet the needs of my users.
