FireDAC.Comp.Client.TFDCustomCommand.ParamBindMode

From RAD Studio API Documentation
Jump to: navigation, search

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

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