I'm using a cursor to get a rowset and then update that rowset with certain new values. So I have a basic while loop to check until @.@.fetch_status is not zero. However, this means that it tries to fetch one time a row that does not exist before it exists the loop. This gives out an error message that the query had an error in it. I know it's not an error, but is there any way way to avoid that? Is there a way to peek ahead to see if I'm currently fetching the last row and exit before trying to fetch another one? Maybe there is a way to see how many rows were returned when the cursor was opened? This is a dynamic cursor so @.@.CURSOR_ROWS won't work as far as I know.
Thank you.What was the exact error?
For more information on cursors refer to books online.|||How about using the dreaded GOTO
WHILE 1 = 1
BEGIN
FETCH NEXT..............
IF (@.@.FETCH_STATUS <> 0) GOTO CloseCursor
......update rowset.......
END
CloseCursor:
CLOSE .........
DEALLOCATE ..........
GWsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment