Record Field Exchange: Using RFX
This topic explains what you do to use RFX in relation to what the framework does.
Note
This topic applies to classes derived from CRecordset in which bulk row fetching has not been implemented. If you are using bulk row fetching, bulk record field exchange (Bulk RFX) is implemented. Bulk RFX is similar to RFX. To understand the differences, see Recordset: Fetching Records in Bulk (ODBC).
The following topics contain related information:
Record Field Exchange: Working with the Wizard Code introduces the main components of RFX and explains the code that the MFC Application Wizard and Add Class (as described in Adding an MFC ODBC Consumer) write to support RFX and how you might want to modify the wizard code.
Record Field Exchange: Using the RFX Functions explains writing calls to the RFX functions in your DoFieldExchange override.
The following table shows your role in relation to what the framework does for you.
Using RFX: You and the Framework
You |
The framework |
|---|---|
Declare your recordset classes with a wizard. Specify names and data types of field data members. |
The wizard derives a CRecordset class and writes a DoFieldExchange override for you, including an RFX function call for each field data member. |
(Optional) Manually add any needed parameter data members to the class. Manually add an RFX function call to DoFieldExchange for each parameter data member, add a call to CFieldExchange::SetFieldType for the group of parameters, and specify the total number of parameters in m_nParams. See Recordset: Parameterizing a Recordset (ODBC). |
|
(Optional) Manually bind additional columns to field data members. Manually increment m_nFields. See Recordset: Dynamically Binding Data Columns (ODBC). |
|
Construct an object of your recordset class. Before using the object, set the values of its parameter data members, if any. |
For efficiency, the framework prebinds the parameters, using ODBC. When you pass parameter values, the framework passes them to the data source. Only the parameter values are sent for requeries, unless the sort and/or filter strings have changed. |
Open a recordset object using CRecordset::Open. |
Executes the recordset's query, binds columns to field data members of the recordset, and calls DoFieldExchange to exchange data between the first selected record and the recordset's field data members. |
Scroll in the recordset using CRecordset::Move or a menu or toolbar command. |
Calls DoFieldExchange to transfer data to the field data members from the new current record. |
Add, update, and delete records. |
Calls DoFieldExchange to transfer data to the data source. |
See Also
Reference
Macros, Global Functions, and Global Variables
Concepts
Record Field Exchange: How RFX Works
Recordset: Obtaining SUMs and Other Aggregate Results (ODBC)