Accessing data using SQL

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

For more information about using the Table API, see Accessing data with the table API.

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 statement reference.

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

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0