MDAC 2.5 SDK - ODBC Samples


 

How to Use Cursor Demo

To connect to a data source, choose the Connect command from the Stmt menu. A list of data sources appears; select one, and then follow the connection procedures for that data source.

Once you have connected to a data source, an empty result set window appears. To retrieve a result set, either enter a query (using the Stmt menu's SQL command) or select one of the ODBC catalog functions (for example, the Stmt menu's Table Information command). If the query or catalog request executes successfully, a result set appears in the window.

Cursor Demo enables you to perform Cursor Library operations. You can select rows by clicking. To delete a selected row, use the Delete Row command in the Fetch menu. To update the values in a selected row, use the Update Row command in the Fetch menu. For information about the operation of the Cursor Library, see the Microsoft ODBC Programmer's Reference.