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

SQL Anywhere 10.0.1 » UltraLite - M-Business Anywhere Programming » Understanding UltraLite for M-Business Anywhere Development » Working with data using SQL

Data retrieval: SELECT Next Page

Navigation with SQL


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

The following methods of the ResultSet object allow you to navigate your result set:

Example

The following code fragment demonstrates how to use the moveFirst method to navigate within a result set.

PrepStmt = conn.prepareStatement( 
    "SELECT ID, Name FROM customer", null );
MyResultSet = PrepStmt.executeQuery( null );
MyResultSet.moveFirst();

The same technique is used for all of the move methods.

For more information about these navigational methods, see ResultSet class.