The following table illustrates the cursor sensitivity that is set in response to different ODBC scrollable cursor types.
ODBC scrollable cursor type | SQL Anywhere cursor |
---|---|
STATIC | Insensitive |
KEYSET-DRIVEN | Value-sensitive |
DYNAMIC | Sensitive |
MIXED | Value-sensitive |
A MIXED cursor is obtained by setting the cursor type to SQL_CURSOR_KEYSET_DRIVEN, and then specifying the number of rows in the keyset for a keyset-driven cursor using SQL_ATTR_KEYSET_SIZE . If the keyset size is 0 (the default), the cursor is fully keyset-driven. If the keyset size is greater than 0, the cursor is mixed (keyset-driven within the keyset and dynamic outside the keyset). The default keyset size is 0. It is an error if the keyset size is greater than 0 and less than the rowset size (SQL_ATTR_ROW_ARRAY_SIZE).
For information about SQL Anywhere cursors and their behavior, see SQL Anywhere cursors.
For information about how to request a cursor type in ODBC, see Choosing ODBC 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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |