Contents Index Navigation with Dynamic SQL  ULResultSet schema property

UltraLite ActiveX User's Guide
  Understanding UltraLite ActiveX Development
    Accessing and manipulating data using Dynamic SQL
      Navigation with Dynamic SQL

Moving through a result set

UltraLite ActiveX provides you with a number of methods to navigate a result set in order to perform a wide range of navigation tasks.

The following methods allow you to navigate your result set:

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

' eMbedded Visual Basic
Set x = Connection.PrepareStatement( "SELECT ID, Name FROM customer")
Set MyResultSet = x.ExecuteQuery
MyResultSet.MoveFirst
// JScript
x = Connection.PrepareStatement( "SELECT ID, Name FROM customer");
MyResultSet = x.ExecuteQuery();
MyResultSet.MoveFirst();

The same technique is used for all of the Move methods. For more information about these navigational methods, see ULResultSet class.


Contents Index Navigation with Dynamic SQL  ULResultSet schema property