API:FireDAC.Comp.Client.TFDCommand.Params
Delphi
property Params: TFDParams read FParams write SetParams stored False;
C++
__property Params;
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | FireDAC.Comp.Client.pas FireDAC.Comp.Client.hpp |
FireDAC.Comp.Client | TFDCommand |
Description
The collection of parameters for an SQL command.
FireDAC.Comp.Client.TFDCommand.Params inherits from FireDAC.Comp.Client.TFDCustomCommand.Params. All content below this line refers to FireDAC.Comp.Client.TFDCustomCommand.Params.
The collection of parameters for an SQL command.
The Params property is the collection of parameters for an SQL command.
If CommandKind is not in [skStoredProc, skStoredProcWithCrs, skStoredProcNoCrs], then Params is populated automatically after assigning CommandText, if ResourceOptions.ParamCreate is True.
If CommandKind is in [skStoredProc, skStoredProcWithCrs, skStoredProcNoCrs], then Params is populated automatically after calling the Prepare method, if fiMeta is in FetchOption.Items.
Otherwise, Params may be populated by hand. When calling Prepare, the parameters are bound to the prepared SQL command. After that you cannot change the parameter types, otherwise an exception is raised.