FireDAC.Stan.Option.TFDResourceOptions.EscapeExpand

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property EscapeExpand: Boolean read GetEscapeExpand write SetEscapeExpand  stored IsEPS default True;

C++

__property bool EscapeExpand = {read=GetEscapeExpand, write=SetEscapeExpand, stored=IsEPS, 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 processing of escape sequences.

Use the EscapeExpand property to control the expansion of escape sequences. If it is True, then they will be processed and expanded into target DBMS syntax constructions. If it is False, then FireDAC will ignore escape sequences. The default value is True

Setting EscapeExpand to False may be usefull in the following conditions:

  • Target DBMS uses '{', '}' symbols in its own SQL dialect and FireDAC cannot recognize them as an SQL construction. Also, SQL commands with these symbols may confuse the FireDAC SQL preprocessor. See Preprocessing Command Text for a description of escape sequences.
  • The application does not use escape sequences.

Setting PreprocessCmdText to False assigns a False value to EscapeExpand.

See Also