UltraLite.NET User's Guide
Understanding UltraLite Development
Accessing and manipulating data with dynamic SQL
Navigating through dynamic SQL result sets
The result set object provides you with a number of methods to navigate a result set.
The following methods allow you to navigate your 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. Zero is useful if you want to repopulate a row buffer.