Result Sets

ODBC applications use cursors to manipulate and update result sets. The Adaptive Server ODBC Driver provides extensive support for different kinds of cursors and cursor operations.

Choosing Cursor Characteristics
Use cursors to carry out tasks for ODBC functions that execute statements and manipulate result sets.
UseCursor Connection Property
The UseCursor connection property determines the type of cursor generated by the Adaptive Server ODBC Driver.
Retrieving Data
Retrieve data from a database using SQL statements.
Updating and Deleting Rows Through a Cursor
Set the statement attribute SQL_ATTR_CONCURRENCY to SQL_CONCUR_LOCK to open a cursor to update or delete rows.
Scrollable Cursors
Scrollable cursors can go backward as well as forward to more easily support screen-based applications.

Parent topic: ODBC Programming