UltraLite ActiveX User's Guide
Understanding UltraLite ActiveX Development
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 Accessing and manipulating 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 dynamic SQL features, see Dynamic SQL.
The sequence of operations required is similar for any SQL operation. For an overview, see Using dynamic SQL.
Data manipulation: INSERT, UPDATE and DELETE
Data retrieval: SELECT
Navigation with dynamic SQL
ULResultSet schema property
SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.