This topic has not yet been rated - Rate this topic

CDaoQueryDef Members

Visual Studio 2010

Base Class 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.

Reference

CDaoQueryDef Class

Hierarchy Chart

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD