Scrollable cursors can move backward and forward in a result set, allowing the application user to scroll back and forth through requested data.
• A static cursor is one that does not detect any changes made to the record after the cursor is opened. For example, if a static cursor fetches a row and another application then updates that row, the values would be unchanged when that row is fetched again.
• A keyset-driven cursor detects value changes to the record using keys that are saved when the cursor is opened to retrieve the current data values for each row.
OpenAccess SDK supports forward-scrolling static cursors when accessing a data source through the OpenAccess SDK SQL engine. The ODBC client simulates forward and backward scrolling.
A keyset-driven scrollable cursor can be used if the driver is used with a third-party SQL engine that supports the ability to identify unique rows, such as a rowid column. The name and other properties of the auto-unique column must be configured in the data source of the OpenAccess SDK Server.
Note: The SQL_MAX_CURSOR_NAME_LEN attribute is not supported. By default, the attribute returns 18 from the driver.
