Contents Index Retrieving data Using bookmarks

ASA Programming Guide
  ODBC Programming
    Working with result sets

Updating and deleting rows through a cursor


The Microsoft ODBC Programmer's Reference suggests that you use SELECT... FOR UPDATE to indicate that a query is updateable using positioned operations. You do not need to use the FOR UPDATE clause in Adaptive Server Anywhere: SELECT statements are automatically updateable as long as the following conditions are met:

ODBC provides two alternatives for carrying out positioned updates and deletes:


Contents Index Retrieving data Using bookmarks