Contents Index Topic Contents

SQL Property

Sets or returns the query string used to retrieve the Recordset.

You can set the SQL property at design time in the RDS.DataControl object's OBJECT tags, or at run time in scripting code (for instance, VBScript).

Syntax

	Syntax
Design time	<PARAM NAME="SQL" VALUE="QueryString">
Run time	DataControl.SQL = "QueryString"

Part	Description
QueryString	A String containing a valid SQL data request.
DataControl	An object variable that represents an RDS.DataControl object.

Applies To

RDS.DataControl

Remarks

In general, this is an SQL statement (using the dialect of the database server), such as "Select * from NewTitles". To ensure that records are matched and updated accurately, an updatable query must contain a field other than a Long Binary field or a computed field.

The SQL property is optional if a custom server-side business object retrieves the data for the client.

Example

See Also

Connect Property, Query Method, Refresh Method, SubmitChanges Method

---

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