Contents Index Navigating through dynamic SQL result sets Result set schema description

UltraLite for MobileVB User's Guide
  Understanding UltraLite for MobileVB Development
    Accessing data using dynamic SQL
      Navigating through dynamic SQL result sets

Move through a result set

UltraLite for MobileVB provides you with a number of methods to navigate a result set. To call your method, use the following model to guide your writing: MyResultSetName.MethodName.

The following methods allow you to navigate your result set:

The following example shows you how you can use MoveFirst to navigate within a result set.

 Set x = Connection.PrepareStatement( _
"SELECT ID, Name FROM customer")
 Set MyResultSet = x.ExecuteQuery
 MyResultSet.MoveFirst

Contents Index Navigating through dynamic SQL result sets Result set schema description