Accessing and manipulating data with the Table API

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

For more information about SQL, see Accessing and manipulating data using SQL.

This section explains how to perform the following tasks using the Table API:

  • Scroll through the rows of a table.

  • Access the values of the current row.

  • Use find and lookup methods to locate rows in a table.

  • Insert, delete, and update rows.

Navigating the rows of a table
Using UltraLite modes
Accessing the values of the current row
Searching rows with find and lookup
Updating rows
Inserting rows
Deleting rows

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0