CDaoFieldExchange Class

Supports the DAO record field exchange (DFX) routines used by the DAO database classes.

Note

DAO is supported through Office 2013. DAO 3.6 is the final version, and it's considered obsolete.

Syntax

class CDaoFieldExchange

Members

Public Methods

Name Description
CDaoFieldExchange::IsValidOperation Returns nonzero if the current operation is appropriate for the type of field being updated.
CDaoFieldExchange::SetFieldType Specifies the type of recordset data member — column or parameter — represented by all subsequent calls to DFX functions until the next call to SetFieldType.

Public Data Members

Name Description
CDaoFieldExchange::m_nOperation The DFX operation being performed by the current call to the recordset's DoFieldExchange member function.
CDaoFieldExchange::m_prs A pointer to the recordset on which DFX operations are being performed.

Remarks

CDaoFieldExchange does not have a base class.

Use this class if you are writing data exchange routines for custom data types; otherwise, you will not directly use this class. DFX exchanges data between the field data members of your CDaoRecordset object and the corresponding fields of the current record on the data source. DFX manages the exchange in both directions, from the data source and to the data source. See Technical Note 53 for information about writing custom DFX routines.

Note

The DAO database classes are distinct from the MFC database classes based on Open Database Connectivity (ODBC). All DAO database class names have the "CDao" prefix. You can still access ODBC data sources with the DAO classes. In general, the MFC classes based on DAO are more capable than the MFC classes based on ODBC. The DAO-based classes can access data, including through ODBC drivers, via their own database engine. They also support Data Definition Language (DDL) operations, such as adding tables via the classes instead of having to call DAO yourself.

Note

DAO record field exchange (DFX) is very similar to record field exchange (RFX) in the ODBC-based MFC database classes ( CDatabase, CRecordset). If you understand RFX, you will find it easy to use DFX.

A CDaoFieldExchange object provides the context information needed for DAO record field exchange to take place. CDaoFieldExchange objects support a number of operations, including binding parameters and field data members and setting various flags on the fields of the current record. DFX operations are performed on recordset-class data members of types defined by the enum FieldType in CDaoFieldExchange. Possible FieldType values are:

  • CDaoFieldExchange::outputColumn for field data members.

  • CDaoFieldExchange::param for parameter data members.

The IsValidOperation member function is provided for writing your own custom DFX routines. You will use SetFieldType frequently in your CDaoRecordset::DoFieldExchange functions. For details about the DFX global functions, see Record Field Exchange Functions. For information about writing custom DFX routines for your own data types, see Technical Note 53.

Inheritance Hierarchy

CDaoFieldExchange

Requirements

Header: afxdao.h

CDaoFieldExchange::IsValidOperation

If you write your own DFX function, call IsValidOperation at the beginning of your function to determine whether the current operation can be performed on a particular field data member type (a CDaoFieldExchange::outputColumn or a CDaoFieldExchange::param).

BOOL IsValidOperation();

Return Value

Nonzero if the current operation is appropriate for the type of field being updated.

Remarks

Some of the operations performed by the DFX mechanism apply only to one of the possible field types. Follow the model of the existing DFX functions.

For additional information on writing custom DFX routines, see Technical Note 53.

CDaoFieldExchange::m_nOperation

Identifies the operation to be performed on the CDaoRecordset object associated with the field exchange object.

Remarks

The CDaoFieldExchange object supplies the context for a number of different DFX operations on the recordset.

Note

The PSEUDONULL value described under the MarkForAddNew and SetFieldNull operations below is a value used to mark fields Null. The DAO record field exchange mechanism (DFX) uses this value to determine which fields have been explicitly marked Null. PSEUDONULL is not required for COleDateTime and COleCurrency fields.

Possible values of m_nOperation are:

Operation Description
AddToParameterList Builds the PARAMETERS clause of the SQL statement.
AddToSelectList Builds the SELECT clause of the SQL statement.
BindField Binds a field in the database to a memory location in your application.
BindParam Sets parameter values for the recordset's query.
Fixup Sets the Null status for a field.
AllocCache Allocates the cache used to check for "dirty" fields in the recordset.
StoreField Saves the current record to the cache.
LoadField Restores the cached data member variables in the recordset.
FreeCache Frees the cache used to check for "dirty" fields in the recordset.
SetFieldNull Sets a field's status to Null and value to PSEUDONULL.
MarkForAddNew Marks fields "dirty" if not PSEUDONULL.
MarkForEdit Marks fields "dirty" if they do not match the cache.
SetDirtyField Sets field values marked as "dirty."
DumpField Dumps a field's contents (debug only).
MaxDFXOperation Used for input checking.

CDaoFieldExchange::m_prs

Contains a pointer to the CDaoRecordset object associated with the CDaoFieldExchange object.

Remarks

CDaoFieldExchange::SetFieldType

Call SetFieldType in your CDaoRecordset class's DoFieldExchange override.

void SetFieldType(UINT nFieldType);

Parameters

nFieldType
A value of the enum FieldType, declared in CDaoFieldExchange, which can be either of the following:

  • CDaoFieldExchange::outputColumn

  • CDaoFieldExchange::param

Remarks

Normally, ClassWizard writes this call for you. If you write your own function and are using the wizard to write your DoFieldExchange function, add calls to your own function outside the field map. If you do not use the wizard, there will not be a field map. The call precedes calls to DFX functions, one for each field data member of your class, and identifies the field type as CDaoFieldExchange::outputColumn.

If you parameterize your recordset class, you should add DFX calls for all parameter data members (outside the field map) and precede these calls with a call to SetFieldType. Pass the value CDaoFieldExchange::param. (You can, instead, use a CDaoQueryDef and set its parameter values.)

In general, each group of DFX function calls associated with field data members or parameter data members must be preceded by a call to SetFieldType. The nFieldType parameter of each SetFieldType call identifies the type of the data members represented by the DFX function calls that follow the SetFieldType call.

See also

Hierarchy Chart
CDaoRecordset Class