ASA Programming Guide
Using SQL in Applications
Choosing cursor types
Requesting Adaptive Server Anywhere cursors
The following table illustrates the cursor sensitivity that is set in response to different ODBC scrollable cursor types.
| ODBC scrollable cursor type | Adaptive Server Anywhere cursor |
|---|---|
| STATIC | Insensitive |
| KEYSET | Value-sensitive |
| DYNAMIC | Sensitive |
| MIXED | Value-sensitive |
For information on Adaptive Server Anywhere cursors and their behavior, see Adaptive Server Anywhere cursors. For information on how to request a cursor type in ODBC, see Choosing a cursor characteristics.
If a STATIC cursor is requested as updatable, a value-sensitive cursor is supplied instead and a warning is issued.
If a DYNAMIC or MIXED cursor is requested and the query cannot be executed without using work tables, a warning is issued and an asensitive cursor is supplied instead.