FireDAC.Stan.Option.TFDFormatOptions.QuoteIdentifiers

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property QuoteIdentifiers: Boolean read GetQuoteIdentifiers  write SetQuoteIdentifiers stored IsQIDS default False;

C++

__property bool QuoteIdentifiers = {read=GetQuoteIdentifiers, write=SetQuoteIdentifiers, stored=IsQIDS, default=0};

Properties

Type Visibility Source Unit Parent
property published
FireDAC.Stan.Option.pas
FireDAC.Stan.Option.hpp
FireDAC.Stan.Option TFDFormatOptions

Description

Specifies whether or not to explicitly surround identifiers with quotes.

Use the QuoteIdentifiers property to explicitly quote identifiers, such as column and table names. This helps if the identifiers in a database are quoted and must not be normalized but pointed in all queries as they were defined. 

Normally, FireDAC automatically decides if it should quote an identifier or not. However, in several cases, an application needs to specify to FireDAC to quote identifiers: when a DB table has quoted column names and this table is specified in TableName.

See Also