Sets or returns the query string used to retrieve the Recordset.
You can set the SQL property at design time in the AdvancedDataControl 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 | AdvancedDataControl.SQL = "QueryString" |
| Part | Description |
| QueryString | A String containing a valid SQL-92 data request. |
| AdvancedDataControl | An object variable that represents an AdvancedDataControl object. |
Applies To
Remarks
In general, this is an SQL statement (using SQL-92 syntax), such as "Select * from NewTitles". If the data source is Microsoft SQL Server, you can add a for browse clause to the end of the query to enable keyset editing. 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.
See Also
Connect Property, Query Method, Refresh Method, SubmitChanges Method
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.