| title | SQL Property | Microsoft Docs | |
|---|---|---|
| ms.technology | connectivity | |
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.reviewer | ||
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.topic | conceptual | |
| apitype | COM | |
| helpviewer_keywords |
|
|
| ms.assetid | e0dabf23-a159-4fe5-a962-3df544a21f5c | |
| author | MightyPen | |
| ms.author | genemi |
Indicates 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.
Important
Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and Windows Server 2012 Compatibility Cookbook for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to WCF Data Service.
Design time: <PARAM NAME="SQL" VALUE="QueryString">
Run time: DataControl.SQL = "QueryString"
QueryString
A String value that contains a valid SQL data request.
DataControl
An object variable that represents an RDS.DataControl object.
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.
SQL Property Example (VBScript)
Connect Property (RDS)
Query Method (RDS)
Refresh Method (RDS)
SubmitChanges Method (RDS)