CDaoQueryDef Members

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

Concepts

CDaoQueryDef Class

Hierarchy Chart