Contents Index Updating and deleting rows through a cursor Calling stored procedures

ASA Programming Guide
  ODBC Programming
    Working with result sets

Using bookmarks


ODBC provides bookmarks, which are values used to identify rows in a cursor. Adaptive Server Anywhere supports bookmarks for all kinds of cursors except dynamic cursors.

Before ODBC 3.0, a database could specify only whether it supported bookmarks or not: there was no interface to provide this information for each cursor type. There was no way for a database server to indicate for what kind of cursor bookmarks were supported. For ODBC 2 applications, Adaptive Server Anywhere returns that it does support bookmarks. There is therefore nothing to prevent you from trying to use bookmarks with dynamic cursors; however, you should not use this combination.


Contents Index Updating and deleting rows through a cursor Calling stored procedures