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.