|
|
|
NOTE: This Design document is subject to change at any time. |
Params: ParamCollection
This property is used to change any SQL parameters used in the Text property. To retrieve or change a parameter, use the syntax: Query.Params.ParamsValues("ParamName")
For example, in the SQL statement:
Query.Text = "SELECT * FROM Table WHERE Key = :KeyParam"
Query.Params.ParamsValue("KeyParam") = "MyKey"
This expands to the SQL query:
SELECT * FROM Table WHERE Key = 'MyKey'
Note the colon : syntax for specifying a parameter in the SQL statement. While parameters can be used in any query, they are more useful when dealing with stored procedures. |
|