Data creation and modification using SQL statements

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

For information about the Table API, see Data creation and modification using the Table API.

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

  • Inserting, deleting, and updating rows.

  • Executing a query.

  • 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 Anywhere Server - SQL Reference.


Modifying data using INSERT, UPDATE, and DELETE
Retrieving data using SELECT
SQL result set navigation
ResultSetSchema objects