Data.Win.ADODB.TParameters.ParamValues
Delphi
property ParamValues[const ParamName: WideString]: Variant read GetParamValue write SetParamValue;
C++
__property System::Variant ParamValues[const System::WideString ParamName] = {read=GetParamValue, write=SetParamValue};
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
property | public | Data.Win.ADODB.pas Data.Win.ADODB.hpp |
Data.Win.ADODB | TParameters |
Description
Retrieves the value of one or more parameters.
Use ParamValues to get or set the individual values of parameters identified by name.
ParamName contains the names of the individual parameters of interest. If ParamValues is used to access more than one parameter, the names are separated by semicolons (;).
Setting ParamValues sets the Value property for each parameter listed in the ParamName string. Specify the values as Variants, in order, in a variant array.
Getting ParamValues retrieves a variant array of variants, each of which represents the value of one of the named parameters.
If ParamName includes a name that does not match any of the field parameters in Items, an exception is raised.
Note: ParamValues operates with the names of parameters as they appear in an SQL statement or stored procedure, not the Name property of TParameter objects. The two should not be confused.