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

SQL Anywhere 12.0.1 » UltraLite - M-Business Anywhere Programming (deprecated) » UltraLite development for M-Business Anywhere


Data creation and modification using the Table API

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

For information about SQL, see Data creation and modification using SQL statements.

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

  • Scrolling through the rows of a table.

  • Accessing the values of the current row.

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

  • Inserting, deleting, and updating rows.

SQL result set navigation
Access values of the current row
Searching rows with find and lookup
Inserting, updating, and deleting rows
BLOB data types
Transaction management