UltraLite for M-Business Anywhere User's Guide

Understanding UltraLite for M-Business Anywhere Development

Working with data using dynamic SQL

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.

• Inserting, deleting, and updating rows.

• Executing a query.

• Scrolling through the rows of a result set.

This section does not describe the SQL language itself. For information about dynamic SQL features, see 动态 SQL.

The sequence of operations required is similar for any SQL operation. For an overview, see 使用动态 SQL.

Data manipulation: INSERT, UPDATE and DELETE
Data retrieval: SELECT
Navigation with dynamic SQL
The ResultSetSchema object

SQL Anywhere Studio 9.0.2
版权所有 © 1989–2005 Sybase, Inc. 部分版权所有 © 2001–2005 iAnywhere Solutions, Inc. 保留所有权利。