Accessing data using SQL statements

UltraLite applications can access table data by executing SQL statements or using the ULTable class. This section describes data access using SQL statements.

This section explains how to perform the following tasks using SQL:

  • Inserting, deleting, and updating rows.

  • Retrieving rows to a result set.

  • Scrolling through the rows of a result set.

This section does not describe the SQL language. For more information about the SQL language, see UltraLite SQL statements.

For more information about using the ULTable class, see Accessing data using ULTable class.


Data manipulation: Insert, Delete, and Update
Data retrieval: SELECT
Navigating SQL result sets
Result set schema description