FireDAC.Stan.Option.TFDResourceOptions.ParamExpand

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property ParamExpand: Boolean read GetParamExpand write SetParamExpand

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.

See Also