Data creation and modification using SQL statements

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

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.

 See also

Modifying data using INSERT, UPDATE, and DELETE
Retrieving data using SELECT
Result set schema description
SQL result set navigation