Query Method (RDS)

Uses a valid SQL query string to return a Recordset.

Syntax

Set Recordset = DataFactory.Query Connection, Query

Parameters

Recordset An object variable that represents a Recordset object.

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 query.

Remarks

The query should use the SQL dialect of the database server. A result status is returned if there is an error with the query that was executed. The Query method doesn't perform any syntax checking on the Query string.

See Also

Getting a Recordset to the Client, Appendix B: Detailed Control Flow