|
Name |
Returns |
Description |
|---|---|---|
|
Cancel |
Cancels execution of an asynchronous OpenRecordset method. |
|
|
Close |
Closes an open DAO object. |
|
|
CreateProperty |
Creates a new user-defined Property object. |
|
|
Execute |
Executes an action query. |
|
|
OpenRecordset |
Creates a new Recordset object. |
|
Name |
Returns |
Description |
|---|---|---|
|
CacheSize |
Long |
Sets or returns the number of records to be locally cached from an ODBC data source. |
|
Connect |
String |
Sets or returns a value providing information about a data source for a QueryDef . |
|
DateCreated |
Variant |
Returns the date and time when the QueryDef was created. Read-only. |
|
Collection of Field objects in a QueryDef object. Read-only. |
||
|
LastUpdated |
Variant |
Returns the date and time of the most recent change to an object. Read-only. |
|
MaxRecords |
Long |
Indicates the maximum number of records to return from a query. |
|
Name |
String |
Returns the name of this object. |
|
ODBCTimeout |
Integer |
Sets or returns the number of seconds before a timeout occurs on an ODBC database. |
|
Collection of Parameter objects available for a QueryDef object. Read-only. |
||
|
Prepare |
Variant |
Indicates whether to prepare a temporary stored procedure from the query. |
|
Collection of Property objects. Read-only. |
||
|
RecordsAffected |
Long |
Returns the number of records affected by the last Execute method. Read-only. |
|
ReturnsRecords |
Boolean |
Sets or returns a value indicating whether a SQL pass-through returns records. |
|
SQL |
String |
Sets or returns the SQL statement that defines the query. |
|
StillExecuting |
Boolean |
Indicates whether an asynchronous method call is still executing. Read-only. |
|
Type |
Integer |
Sets or returns the data type of an object. |
|
Updatable |
Boolean |
Returns whether the query definition can be change. Read-only. |