FireDAC.Stan.Option.TFDResourceOptions.ParamExpand
Delphi
property ParamExpand: Boolean read GetParamExpand write SetParamExpand stored IsPES default True;
C++
__property bool ParamExpand = {read=GetParamExpand, write=SetParamExpand, stored=IsPES, default=1};
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
property | published | FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp |
FireDAC.Stan.Option | TFDResourceOptions |
Description
Controls the expansion of parameters.
Use the ParamExpand property to control the expansion of parameters. If it is True, then the FireDAC styled markers (:name) will be replaced with the DBMS SQL dialect markers. If it is False, then FireDAC does not replace the parameter markers. The default value is True.
Setting ParamExpand to False may be usefull in the following conditions:
- The SQL command cannot contain any parameters, like a DDL SQL, but a command may contain FireDAC-like markers, which are not the actual parameters. In some cases, such markers may confuse FireDAC.
- The application does not use any parameters.
Setting PreprocessCmdText to False assigns a False value to ParamExpand.