لطفا منتظر باشید ...
QueryDef
Methods
Name | Returns | Description |
|---|---|---|
Cancel | Cancels execution of an asynchronous OpenRecordset method. | |
Close | Closes an open DAO object. | |
CreateProperty | Property | Creates a new user-defined Property object. |
Execute | Executes an action query. | |
OpenRecordset | Recordset | Creates a new Recordset object. |
Properties
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. |
Fields | Fields | 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. |
Parameters | Parameters | Collection of Parameter objects available for a QueryDef object. Read-only. |
Prepare | Variant | Indicates whether to prepare a temporary stored procedure from the query. |
Properties | Properties | 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. |
