Working with data using SQL

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 Working with data 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.

Data manipulation: INSERT, UPDATE and DELETE
Data retrieval: SELECT
Navigation with SQL
The ResultSetSchema object

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