Processing SQL Statements

Important

This feature will be removed in a future version of Windows. Avoid using this feature in new development work and plan to modify applications that currently use this feature. Microsoft recommends using the driver's cursor functionality.

The ODBC cursor library passes all SQL statements directly to the driver except the following:

• Positioned update and delete statements

• SELECT FOR UPDATE statements

• Batched SQL statements

To execute positioned update and delete statements and to position the cursor on a row to call SQLGetData for that row, the cursor library constructs a searched statement that identifies the row.

This section contains the following topics.

• Processing Positioned Update and Delete Statements

• Processing SELECT FOR UPDATE Statements

• Processing Batches of SQL Statements

• Constructing Searched Statements