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 - .NET Programming » Understanding UltraLite.NET development » Accessing and manipulating data with the Table API


Navigating the rows of a table

UltraLite.NET provides you with several methods to navigate a table to perform a wide range of navigation tasks.

The table object provides you with the following methods to navigate a table.

  • 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 table, relative to the current position of the cursor in the table, and negative offset values move backward in the table. An offset value of zero does not move the cursor, but allows you to repopulate the row buffer.