Contents Index Topic Contents

Query Method

Uses a valid SQL query string to return a Recordset.

Syntax

Set Recordset = DataFactory.Query Connection, Query

Part	Description
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.

Applies To

RDSServer.DataFactory

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.

Example

See Also

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

---

 Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.