FireDAC.Comp.Client.TFDCustomQuery.Text

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property Text: String read GetText;

C++

__property System::UnicodeString Text = {read=GetText};

Properties

Type Visibility Source Unit Parent
property public
FireDAC.Comp.Client.pas
FireDAC.Comp.Client.hpp
FireDAC.Comp.Client TFDCustomQuery

Description

Points to the actual text of the SQL query passed to the DBMS CLI.

Text is a read-only property that can be examined to determine the actual contents of the SQL statement passed to the DBMS. For parameterized queries, Text contains the SQL statement with parameters replaced by the parameter substitution symbol (? or another symbol) instead of actual parameter values, substituted macro values, and processed escape sequences. 

In general, there should be no need to examine the Text property. To access or change the SQL statement for the query, use the SQL property. To examine or modify parameters, use the Params property. 

To check what FireDAC sends to the DBMS, consider to use FireDAC monitoring.

See Also