From RAD Studio API Documentation
Jump to: navigation, search


property MacroExpand: Boolean read GetMacroExpand write SetMacroExpand  stored IsMES default True;


__property bool MacroExpand = {read=GetMacroExpand, write=SetMacroExpand, stored=IsMES, default=1};


Type Visibility Source Unit Parent
property published
FireDAC.Stan.Option TFDResourceOptions


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.

See Also