FireDAC.Comp.Client.TFDCustomCommand.Params
Delphi
property Params: TFDParams read FParams write SetParams stored False;
C++
__property Firedac::Stan::Param::TFDParams* Params = {read=FParams, write=SetParams, stored=false};
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
property | public | FireDAC.Comp.Client.pas FireDAC.Comp.Client.hpp |
FireDAC.Comp.Client | TFDCustomCommand |
Description
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.