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 - AppForge Programming » Understanding UltraLite Development with AppForge » Working with data using dynamic SQL

Data retrieval: SELECT Next Page

Navigation with dynamic SQL


UltraLite for MobileVB 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 ULResultSet object allow you to navigate your result set:

Example

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

'MobileVB using VB6
Set PrepStmt = Connection.PrepareStatement( _
    "SELECT ID, Name FROM customer")
Set MyResultSet = PrepStmt.ExecuteQuery
MyResultSet.MoveFirst
'Crossfire using vb.net
PrepStmt = Connection.PrepareStatement( _
    "SELECT ID, Name FROM customer")
MyResultSet = PrepStmt.ExecuteQuery
MyResultSet.MoveFirst

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

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