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

See Also

VBScript Example

Applies To: DataFactory Object (RDSServer)

© 1998-2001 Microsoft Corporation. All rights reserved.