QueryDef Object, QueryDefs Collection Summary
QueryDef Object
A QueryDef object contains these collections, methods, and properties.
Legend:
Available only in a Microsoft Jet workspace.
Available only in an ODBCDirect workspace.
Collections
Fields |
Parameters (default) |
Properties |
Methods
Cancel |
Close |
CreateProperty |
Execute |
OpenRecordset |
Properties
CacheSize |
Connect |
DateCreated |
KeepLocal |
LastUpdated |
LogMessages |
MaxRecords |
Name |
ODBCTimeout |
Prepare |
RecordsAffected |
Replicable |
ReturnsRecords |
SQL |
StillExecuting |
Type |
Updatable |
QueryDefs Collection
A QueryDefs collection appears in each Connection object in an ODBCDirect workspace, and each Database object, and contains these methods and this property.
Methods
Append |
Delete |
Refresh |
Property