UltraLite ActiveX User's Guide
  Understanding UltraLite ActiveX Development

Accessing and manipulating data using Dynamic SQL

UltraLite applications can access data in an Ultralite database using Dynamic SQL or the table API.

For information about the table API, see Accessing and manipulating data using the table API.

The following section explains how to perform the following tasks using Dynamic SQL.

• Scrolling through the rows of a table.

• Accessing the values of the current row.

• Locating rows in a table.

• Inserting, deleting, and updating rows.

Data manipulation: INSERT, UPDATE and DELETE
Data retrieval: SELECT
Navigation with Dynamic SQL
ULResultSet schema property