CDaoQueryDef Members

Article
2013-01-30

Base Class Members

CObject Members

CDaoQueryDef Members

Data Members

CDaoQueryDef::m_pDAOQueryDef	A pointer to the OLE interface for the underlying DAO querydef object.
CDaoQueryDef::m_pDatabase	A pointer to the CDaoDatabase object with which the querydef is associated. The querydef might be saved in the database or not.

Construction

CDaoQueryDef::Append	Appends the querydef to the database's QueryDefs collection as a saved query.
CDaoQueryDef::CDaoQueryDef	Constructs a CDaoQueryDef object. Next call Open or Create, depending on your needs.
CDaoQueryDef::Close	Closes the querydef object. Destroy the C++ object when you finish with it.
CDaoQueryDef::Create	Creates the underlying DAO querydef object. Use the querydef as a temporary query, or call Append to save it in the database.
CDaoQueryDef::Open	Opens an existing querydef stored in the database's QueryDefs collection.

Attributes

CDaoQueryDef::CanUpdate	Returns nonzero if the query can update the database.
CDaoQueryDef::GetConnect	Returns the connection string associated with the querydef. The connection string identifies the data source. (For SQL pass-through queries only; otherwise an empty string.)
CDaoQueryDef::GetDateCreated	Returns the date the saved query was created.
CDaoQueryDef::GetDateLastUpdated	Returns the date the saved query was last updated.
CDaoQueryDef::GetName	Returns the name of the querydef.
CDaoQueryDef::GetODBCTimeout	Returns the timeout value used by ODBC (for an ODBC query) when the querydef is executed. This determines how long to allow for the query's action to complete.
CDaoQueryDef::GetRecordsAffected	Returns the number of records affected by an action query.
CDaoQueryDef::GetReturnsRecords	Returns nonzero if the query defined by the querydef returns records.
CDaoQueryDef::GetSQL	Returns the SQL string that specifies the query defined by the querydef.
CDaoQueryDef::GetType	Returns the query type: delete, update, append, make-table, and so on.
CDaoQueryDef::IsOpen	Returns nonzero if the querydef is open and can be executed.
CDaoQueryDef::SetConnect	Sets the connection string for a SQL pass-through query on an ODBC data source.
CDaoQueryDef::SetName	Sets the name of the saved query, replacing the name in use when the querydef was created.
CDaoQueryDef::SetODBCTimeout	Sets the timeout value used by ODBC (for an ODBC query) when the querydef is executed.
CDaoQueryDef::SetReturnsRecords	Specifies whether the querydef returns records. Setting this attribute to TRUE is only valid for SQL pass-through queries.
CDaoQueryDef::SetSQL	Sets the SQL string that specifies the query defined by the querydef.

Operations

CDaoQueryDef::Execute	Executes the query defined by the querydef object.
CDaoQueryDef::GetFieldCount	Returns the number of fields defined by the querydef.
CDaoQueryDef::GetFieldInfo	Returns information about a specified field defined in the query.
CDaoQueryDef::GetParameterCount	Returns the number of parameters defined for the query.
CDaoQueryDef::GetParameterInfo	Returns information about a specified parameter to the query.
CDaoQueryDef::GetParamValue	Returns the value of a specified parameter to the query.
CDaoQueryDef::SetParamValue	Sets the value of a specified parameter to the query.

See Also

Reference

CDaoQueryDef Class

Hierarchy Chart