Accessing and manipulating data using SQL

UltraLite applications can access table data using SQL statements or the Table API. This section describes data access using SQL statements.

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

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

  • Inserting, deleting, and updating rows.

  • Executing queries and retrieving rows to a result set.

  • Scrolling through the rows of a result set.

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


Data manipulation: INSERT, UPDATE, and DELETE
Data retrieval: SELECT
Navigating SQL result sets
Result set schema description