Use MFC ODBC Recordsets

|  Overview |  FAQ |  Details |  Sample |  |  ODBC Driver List

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

What do you want to do?

General Recordset Tasks:

• Choose an ODBC recordset type

• Create an ODBC recordset

• Set recordset options

• Select records from an ODBC data source

• Open a recordset

• Requery a recordset

• Close 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

• Override CRecordset::DoFieldExchange

• Initialize recordset field data members

• 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:

• Determine whether a recordset is updatable

• Add a record to a recordset

• Add records in bulk with a recordset

• Edit a record in a recordset

• Delete a record in 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

• Affect how a recordset selects records

• Customize the SQL string for a recordset

Recordset Navigation:

• Scroll (navigate) through a recordset

• Use bookmarks in a recordset

• Use absolute positioning in a recordset

Dynamic Binding of Recordsets:

• Bind data columns in a recordset dynamically at run time