This topic has not yet been rated - Rate this topic

CDaoParameterInfo Structure

Visual Studio 2012

The CDaoParameterInfo structure contains information about a parameter object defined for data access objects (DAO).

struct CDaoParameterInfo 
{ 
   CString m_strName;       // Primary 
   short m_nType;           // Primary 
   ColeVariant m_varValue;  // Secondary 
};

Parameters

m_strName: Uniquely names the parameter object. For more information, see the topic "Name Property" in DAO Help.
m_nType: A value that indicates the data type of a parameter object. For a list of the possible values, see the m_nType member of the CDaoFieldInfo structure. For more information, see the topic "Type Property" in DAO Help.
m_varValue: The value of the parameter, stored in a COleVariant object.

Remarks

The references to Primary and Secondary above indicate how the information is returned by the GetParameterInfo member function in class CDaoQueryDef.

MFC does not encapsulate DAO parameter objects in a class. DAO querydef objects underlying MFC CDaoQueryDef objects store parameters in their Parameters collections. To access the parameter objects in a CDaoQueryDef object, call the querydef object's GetParameterInfo member function for a particular parameter name or an index into the Parameters collection. You can use the CDaoQueryDef::GetParameterCount member function in conjunction with GetParameterInfo to loop through the Parameters collection.

Information retrieved by the CDaoQueryDef::GetParameterInfo member function is stored in a CDaoParameterInfo structure. Call GetParameterInfo for the querydef object in whose Parameters collection the parameter object is stored.

Note
If you want to get or set only the value of a parameter, use the GetParamValue and SetParamValue member functions of class CDaoRecordset.

CDaoParameterInfo also defines a Dump member function in debug builds. You can use Dump to dump the contents of a CDaoParameterInfo object.

Requirements

Header: afxdao.h

Reference

CDaoQueryDef Class

Other Resources

Structures, Styles, Callbacks, and Message Maps

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD