You can navigate through a result set using methods associated with the ULDataReader object.
The result set object provides you with the following methods to navigate a result set:
MoveAfterLast moves to a position after the last row.
MoveBeforeFirst moves to a position before the first row.
MoveFirst moves to the first row.
MoveLast moves to the last row.
MoveNext moves to the next row.
MovePrevious moves to the previous row.
MoveRelative(offset) moves a certain number of rows relative to the current row, as specified by the offset. Positive offset values move forward in the result set, relative to the current position of the cursor in the result set, and negative offset values move backward in the result set. An offset value of zero does not move the cursor, but allows you to repopulate the row buffer.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|