Use MFC ODBC Recordsets

Home |  Overview |  FAQ |  Details |  Sample |  Tutorial |  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