Query Method

Uses a valid SQL-92 query string to return a Recordset.

Syntax

Set Recordset = RDSServer.DataFactory.Query Connection, Query

Part	Description

Recordset	An object variable that represents a Recordset object.
RDSServer.DataFactory	An object variable that represents an RDSServer.DataFactory object.
Connection	A String containing the server connection information. This is similar to the Connect property.
Query	A String containing the SQL-92 query data.

Applies To

RDSServer.DataFactory

Remarks

The query should use SQL-92 syntax. A result status is returned if there is an error with the query that was executed. The Query method does not perform any syntax checking on the Query string.

Example