ReturnsRecords Property
Applies To
QueryDef object.
Description
Sets or returns a value that indicates whether an SQL pass-through query to an external database returns records.
Settings and Return Values
The setting or return value is a Boolean that is True (default) if a pass-through query returns records.
Remarks
Not all SQL pass-through queries to external databases return records. For example, an SQL UPDATE statement updates records without returning records, while an SQL SELECT statement does return records. If the query returns records, set the ReturnsRecords property to True; if the query doesn't return records, set the ReturnsRecords property to False.
Note You must set the Connect property before you set the ReturnsRecords property.
See Also
Connect property, QueryTimeout property, SQL property.
Example
See the LogMessages property example.