Data.Win.ADODB.TParameters.ParamValues

From RAD Studio API Documentation
Jump to: navigation, search

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.

See Also