|
UltraLite applications can access table data using dynamic SQL or the Table API. This section describes data access using dynamic 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 dynamic SQL.
Scrolling through the rows of a table.
Accessing the values of the current row.
Locating rows in a table.
Inserting, deleting, and updating rows.
This section does not describe the SQL language itself. For information about SQL features, see SQL Language Elements.
The sequence of operations required is similar for any SQL operation. For an overview, see SQL Statements.
Data manipulation: INSERT, UPDATE, and DELETE
Data retrieval: SELECT
Navigation with dynamic SQL
ULResultSet schema property