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

SQL Anywhere 12.0.1 » UltraLite - M-Business Anywhere Programming (deprecated) » UltraLite development for M-Business Anywhere » Data creation and modification using the Table API


SQL result set navigation

UltraLite for M-Business Anywhere provides you with many methods to navigate a table to perform a wide range of navigation tasks.

The following methods of the ULTable object 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   moves a certain number of rows relative to the current row. Positive index values move forward in the table, negative index values move backward in the table, and zero does not move the cursor. Zero is useful if you want to repopulate a row buffer.

 Specifying an index