Use MFC ODBC Recordsets

These topics explain how to work with ODBC recordsets through MFC.

In This Section

General Recordset Tasks

• Choose an ODBC recordset type

• Requery a recordset

• Declare a recordset class for a table

• Declare a recordset class for a predefined query

Recordset Design and Implementation

• Learn about record field exchange (RFX)

• Exchange data between a database and a recordset object

• Customize recordset code produced by the wizards

• Use the record field exchange (RFX) functions

Recordset Performance and Convenience

• Add records in bulk with a recordset

• Filter records in a recordset

Recordset Operations

• Add records in bulk with a recordset

• Requery a recordset

• Filter records in a recordset

• Sort records in a recordset

• Parameterize a recordset

• Pass parameter values to a recordset at run time

• Perform a join with a recordset

• Lock records in a recordset

• Work with large data items in a recordset

• Obtain SUMs and other aggregate results in a recordset

Recordset Selection and SQL

• Select records from an ODBC data source

• Customize the SQL string for a recordset

Dynamic Binding of Recordsets

• Bind data columns in a recordset dynamically at run time

See also

Open Database Connectivity (ODBC)