Dave: As we found out from the recent batch of comments on this subject, the WHILE SQLCODE <> 100 works *ONLY* if the "fetch" statement is the last command before the ENDWHILE.
Some people, including myself, don't program that way because it requires you to have 2 fetches in the code. Karen > Hi, > > I too am converting an old database with lots of SET POINTER commands. > What I have found works is to use: > > WHILE SQLCODE <>100 THEN > > In place of any old line that looks like > > WHILE var = 0 THEN > > This seems to run the cursor/pointer through the data and stop at the > end without any problems. > > Regards, > Dave Fitts > State of Maine
