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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Java Programming » UltraLiteJ application development


Quick start guide to schema operations and data management

Create, update, or retrieve tables, indexes, foreign keys, publications, and rows in your database using SQL statements and queries.


Some SQL statements are not supported for BlackBerry smartphones.

When performing schema operations to manage data, you typically perform the following tasks in your application code:

  1. Perform schema operations.

    Manage and modify the schema by using SQL statements such as CREATE TABLE or CREATE INDEX on the database connection.

  2. Manage row operations.

    Manage data in tables using SQL statements such as INSERT, UPDATE, or DELETE on the database connection.

  3. Retrieve row data in a result set.

    Retrieve a result set using the SELECT statement, and then traverse the row data using result set navigation methods, such as previous and next.

Example: Managing database operations on an Android smartphone
Schema operations
Row operation management
Row data retrieval