J. Stephen Wills wrote: >I have a situation where, at least f/now, it seems best to CURSOR into one >table, then, f/ea record, CURSOR into another table f/matching records. My >problem is managing SQLCODE values. Is it possible to use something other >than ... > >WHILE SQLCODE <> 100 THEN >... >ENDWHILE > >That is, could I set a variable equal to SQLCODE at the appropriate points, >such as after a FETCH, and test that variable? > >
You may also be able to count the number of fits to your criteria and then decrease the value each loop until 0 to break out of your loop. WHILE VCTR > 0 THEN ... ENDWHILE Nicky ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
