>From the Help system on OPEN:
When using the RESET option, the WHERE clause is evaluated with the current values of any referenced variables, and the cursor is reopened without requiring a CLOSE command. The cursor is positioned at the beginning of the result set when the FETCH command is run. How about that. I thought you had to issue the CLOSE before another OPEN RESET. There’s my learning for the day; I can start ignoring everything else now. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, June 10, 2009 10:59 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Nested While with Fetch I have never once used a CLOSE. I think the RESET takes care of that. Karen Karen, Don’t you need a CLOSE lit2 just before the BREAK in the IF SQLCODE = 100 block?
