FireDAC.Comp.Client.TFDCustomCommand.ParamBindMode

• Up to Parent: TFDCustomCommand

[–] Properties Type: property Visibility: public Source:

FireDAC.Comp.Client.pas

FireDAC.Comp.Client.hpp

Unit: FireDAC.Comp.Client Parent: TFDCustomCommand

Delphi

property ParamBindMode: TFDParamBindMode read GetParamBindMode

C++

__property Firedac::Stan::Param::TFDParamBindMode ParamBindMode = {read=GetParamBindMode, write=SetParamBindMode, default=0};

Description

Determines the order in which a component’s parameters are assigned to the parameter list for the SQL command in the DBMS.

Get or set ParamBindMode to determine the order in which the parameters in the Params property are matched to the parameters used by the SQL command on the server. ParamBindMode can have one of the following values:

Value	Order
pbByName	Parameters specified in the Params property are matched to identically named parameters on the server. This is the default.
pbByNumber	Parameters in Params are assigned one-by-one to the next available parameter on the server (for example, the first parameter in Params is assigned to the first parameter used by the SQL command, and so on).

Whenever possible, ParamBindMode should be pbByName. This guarantees that the parameters are matched to the correct parameters used by the SQL command regardless of physical ordering in Params.

At design time, the names of known parameters appear in the Parameters editor.

See Also

• FireDAC.Comp.Client.TFDCustomCommand.Params