ADO » DataFactory » Query
- Syntax:
- Set recordsetobject = datafactoryobject.Query(ConnectionString, QueryString)
- ConnectionString
- The ConnectionString parameter is a string that contains the details of the server connection information.
- QueryString
- The QueryString parameter is a string that contains the SQL query.
Executes a valid SQL query and returns a Recordset object.
The Query method executes a valid SQL query string and returns the resultant
Recordset object.
The query string must use the type (dialect) of SQL that is recognized by the provider.
This method does not perform a syntax check on the query string.
There are two mandatory parameters.
Examples
Code:
Set objDataFactory = objRDS.CreateObject("RDSServer.DataFactory", strConnURL)
...
Dim objRecordset
Set objRecordset = objDataFactory.Query(strConnection, strQuery)
See Also:
