ADO » DataControl » SQL
- Syntax:
- string = datacontrolobject.SQL
datacontrolobject.SQL = string
Important-
This feature 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.
The SQL property is deprecated in ADO.
Sets or returns the SQL query string.
The SQL property sets or returns a string that is an SQL query that is used by RDS to retrieve the Recordset. The string must use the type of dialect of SQL that is recognized by the server.
You can create a form on a Web page to input values for the various DataControl properties and use Request.Form( ) to assign the values.
Examples
Code:
objDC.ExecuteOptions = Request.Form("ExecuteOptions")
objDC.FetchOptions = Request.Form("FetchOptions")
objDC.InternetTimeout = Request.Form("InternetTimeout")
objDC.Server = Request.Form("Server.Value")
objDC.SourceRecordset = Request.Form("SourceRecordset")
objDC.SQL = Request.Form("SQL")
objDC.URL = Request.Form("URL")
objDC.Connect = Request.Form("Connect")
objDC.Refresh See Also:
