Query method (RDS)
Applies to: Access 2013, Office 2013
Uses a valid SQL query string to return a Recordset.
Syntax
SetRecordset = DataFactory.Query(Connection, Query)
Parameters
| Parameter | Description |
|---|---|
| Recordset | An object variable that represents a Recordset object. |
| DataFactory | An object variable that represents an RDSServer.DataFactory object. |
| Connection | A String value that contains the server connection information. This is similar to the Connect property. |
| Query | A String that contains 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.