Understanding UltraLite.NET 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 using the Table API, see Accessing and manipulating data with the Table API.
This section explains how to perform the following tasks using dynamic SQL.
Inserting, deleting, and updating rows.
Retrieving rows to a result set.
Scrolling through the rows of a result set.
This section does not describe the SQL language itself. For information about dynamic SQL features, see Dynamic SQL.
For an overview of the sequence of operations required for any SQL operation, see Using dynamic SQL.
Data manipulation: INSERT, UPDATE and DELETE
Data retrieval: SELECT
Navigating dynamic SQL result sets
Result set schema description
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.