FireDAC.Comp.Client.TFDCustomCommand.ParamBindMode
Delphi
property ParamBindMode: TFDParamBindMode read GetParamBindMode write SetParamBindMode default pbByName;
C++
__property Firedac::Stan::Param::TFDParamBindMode ParamBindMode = {read=GetParamBindMode, write=SetParamBindMode, default=0};
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
property | public | FireDAC.Comp.Client.pas FireDAC.Comp.Client.hpp |
FireDAC.Comp.Client | TFDCustomCommand |
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 |
---|---|
|
Parameters specified in the Params property are matched to identically named parameters on the server. This is the default. |
|
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.