You can navigate through a result set using methods associated with the ResultSet object.
The result set object provides you with the following methods to navigate a result set:
AfterLast Position immediately after the last row.
BeforeFirst Position immediately before the first row.
First Move to the first row.
Last Move to the last row.
Next Move to the next row.
Previous Move to the previous row.
Relative(offset) Move a specified number of rows relative to the current row, as specified by the signed offset value. Positive offset values move forward in the result set, relative to the current position of the cursor in the result set. Negative offset values move backward in the result set. An offset value of zero does not move the current location, but allows you to repopulate the row buffer.
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |