Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » UltraLite - C and C++ Programming » Application development » Developing applications using the UltraLite C++ API » Accessing data using SQL statements


Navigating SQL result sets

You can navigate through a result set using methods associated with the ULResultSet class. For more information about the ULResultSet class, see ULResultSet class.

The result set class 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 pointer position 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.