Is there a way to Inspect sql statements being fired by TFDConnection?

Database
1

I am using a TMS XData Rest server with TFDConnection (FireDAC) to Msql.

I would like to inspect (log) the sql statements being fired. Is there a hook for it?

2

Yes, Rohit, have a look here:
https://docwiki.embarcadero.com/RADStudio/Athens/en/Tracing_and_Monitoring_(FireDAC)

3

Thanks Mathias.

It will do the job. Its a pity you can’t use a filter by tablename :slight_smile:

I am perplexed by this statement in the docWiki

  • TFDQuery.Text–returns the SQL command text as it will be sent to a database.

I am not sure how this fits in to the monitor component.