FireDAC.Comp.Client.TFDCustomCommand.Params

From RAD Studio API Documentation
Jump to: navigation, search

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.

See Also