FireDAC.Stan.Option.TFDResourceOptions.MacroExpand
Delphi
property MacroExpand: Boolean read GetMacroExpand write SetMacroExpand
C++
__property bool MacroExpand = {read=GetMacroExpand, write=SetMacroExpand, stored=IsMES, 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 macros.
Use the MacroExpand property to control the macros expansion. If it is True, then their values will be substituted into an SQL command text, instead of the corresponding macro markers. If it is False, then FireDAC does not substitute macro values into the command text. The default value is True.
Setting MacroExpand to False may be usefull in the following conditions:
- The target DBMS uses '!', '&' symbols in its own SQL dialect and FireDAC cannot recognize them as an SQL construction. Also, the SQL commands with these symbols may confuse the FireDAC SQL preprocessor. See Preprocessing Command Text for macros description.
- The application does not use any macros.
Setting PreprocessCmdText to False assigns a False value to MacroExpand.