SQL Property (Professional Edition Only)
See Also Example
Applies To
QueryDef object.
Description
Defines a QueryDef Not available at design time; read/write at run time.
Syntax
querydef.SQL [ = sqlstatement ]
Remarks
The SQL property contains the SQL statement You can use the query to select records for a Dynaset or Snapshot or to update a recordset .
If the SQL statement includes parameters Until you reset the parameters, the same parameter values are applied each time you use the query. You set the parameters using the following syntax:
querydef ! parameter = parametervalue
Data Type
String