|
|
|
|
|
|
CLASS: |
|
|
|
|
Parameters |
|
|
|
|
|
|||
|
DESCRIPTION: |
|
|
|
|
ADOParameterArray of ADOParameter objects for an ADO SQL statement or ADO Stored Procedure call. |
|
||
|
|
|
||
|
|
|||
|
|
|||
|
PROPERTY: |
DEFAULT: |
DESCRIPTION: |
|
|
baseClassName |
ADOPARAMETERARRAY |
Identifies the object as an instance of the ADOParameterArray class. |
|
|
className |
ADOPARAMETERARRAY |
Identifies the object as an instance of a custom class. When no custom class exists, defaults to baseClassName |
|
|
parent |
object |
reference to the object that contains the parameters object |
|
|
size |
0 |
Number of ADOParameter objects within the parameters object |
|
|
|
|
|
|
|
|
|
||
|
METHOD: |
PARAMETERS: |
DESCRIPTION: |
|
|
add |
<objRef> |
Add a specified ADOParameter object to the parameters object |
|
|
clear |
|
Removes all ADOParameter objects from the parameters object |
|
|
delete |
<objRef> |
Removes a specified ADOParameter object for the parameters object |
|
|
find |
<stringC> |
Returns object reference of parameter name searched for or null if not found |
|
|
refresh |
|
Reloads list of ADOParameters when available from database server. |
|
|
|
|
|
|
|
|
|
||
|
|
|
||
|
DESCRIPTION: The parameters property is an object array of class ADOParameterArray. It can contain zero or more ADOParameter objects representing the parameters specified in a SQL statement. You may add ADOParameter objects to the parameters array as follows: q = new adoquery() p = new adoparameter() p.name = "Name" p.type = "WChar" p.value = "Smith" p.length = 5 q.parameters.add(p) You may access an existing ADOParameter via its previously assigned name: ? q.parameters["Name"].value
Or, you may access ADOParameters via their numeric array index: ? q.parameters[1].value
To iterate through all ADOParameters: for ctr = 1 to q.parameters.size ? q.parameters[ctr].name, q.parameters[ctr].value endfor
When assigning a SQL statement to the sql property of an ADOQuery, ADOStoredProc, or ADODataShape object, dBASE will automatically search for named parameters within the SQL statement by searching for each of the characters listed in the parameterMarkers property. For each named parameter found, dBASE will create an ADOParameter object and add it to the parameters array. If the SQL statement contains parameter markers other than the default ones, :@, you can modify the parameterMarkers property to include the desired parameter marker(s) prior to setting the sql property. If any ADOParameter objects are created at design time while using one of the visual designers (Form, DataModule, or Report designers) code to create and initialize them will be streamed into the source code file.
NOTE: if getting multi step error... you may need
to recreate the adoquery (rather than just setting it's active
= false then true) when changing the parameters in a sql statement
to clear the ado component in memory. value you get an error 'Invalid argument for value' .... unless you put quotes around the numeric value .. for example in the sample below change parameters["VL"].value = -1 ///where you get the invalid argument error to parameters["VL"].value = "-1"
|
|
||
|
|
|
||
|
|
|
||