Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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|
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.
|Envoyer votre avis sur cette page par email.||Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|