These cursors have insensitive membership, order, and values. No changes made after cursor open time are visible.
Insensitive cursors are used only for read-only cursor types.
Insensitive cursors correspond to the ISO/ANSI standard definition of insensitive cursors, and to ODBC static cursors.
|ODBC, ADO/OLE DB||Static||If an updatable static cursor is requested, a value-sensitive cursor is used instead.|
|JDBC||INSENSITIVE||Insensitive semantics are only supported by the iAnywhere JDBC driver.|
Insensitive cursors always return rows that match the query's selection criteria, in the order specified by any ORDER BY clause.
The result set of an insensitive cursor is fully materialized as a work table when the cursor is opened. This has the following consequences:
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|