|
|
|
|
|
PROPERTY: |
|
|
|
params |
|
|
|
(see also Parameters) |
|
|
|
DESCRIPTION: |
|
|
|
Reference to ADOParameterArray object that contains ADOParameter objects. |
||
|
|
|
|
|
PROPERTY OF: |
|
|
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
|||
|
|
||
|
DEFAULT VALUE: |
|
|
|
Object |
|
|
|
|
|
|
|
OBJECT CLASS: |
|
|
|
|
||
|
|
|
|
|
DESCRIPTION: |
|
|
|
|
||
|
The Params property is a hidden property of ADOQuery, ADOStoredProc, and ADODataShape classes. The recommended way to access ADOParameter objects is via the Parameters property instead. The Params property internally maps to the Parameters property. NOTE: when using params with ADO objects it is important to use the .value property when setting parameter values.
For example in a form that has an ado object...
this.COMPANIES1 = new ADOQUERY(this) with (this.COMPANIES1) beforeConnect = class::COMPANIES1_BEFORECONNECT left = 15.0 top = 4.0 databaseName = "SQLTEST" sql = "SELECT * FROM KathyTest.dbo.Companies where TYPE >= :TYPE1 and TYPE <= :TYPE2 ORDER BY NAME " active = true endwith
function COMPANIES1_beforeConnect this.params["TYPE1"].value = "A" this.params["TYPE2"].value = "Z" return
Other ADOParameter properties may be accessed as well, for example: ? this.params["TYPE1"].length |
||
|
|
||
|
|
|
|
|
|
||
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
|
||
|
|
|
|
|
|
|
|
|
|
|
|