Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

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