DAO Object Classes > DaoQueryDef Class

Purpose

The QueryDef object represents a query in the database and maintains information about the query's properties

Accesses/Assign

The number of records that will be cached locally

Describes the ODBC data source to use for a pass-through query

Date and time when the Querydef was created

Collection of fields in this query

Date and time of the most recent change to the querydef

The maximum number of records that will be returned

Name	The name of this object

Seconds to wait when running a query on an ODBC database

(Default) Collection of parameters available for this query

Should the ODBC query be prepared

Number of records affected by the last Execute() Method

Determines whether a SQL pass-through query returns records

SQL	SQL statement that defines the query

Is the ODBC query still executing

Type	Indicates the data type of the object

Indicates whether the query definition can be changed

Methods

Close the open querydef

Creates a new user-defined Property object

Execute the Querydef (must be non-row returning)

Creates a new Recordset object

Inherits from