Jump to content
Sign in to follow this  
tobenschain

FireDAC generated SQL

Recommended Posts

I am trying to learn SQL and would like to see the commands that FireDAC generates. Is there a routine in FireDAC.DApt.pas that could show me the way?

 

Also, what happened to codenewsfast.com?

Share this post


Link to post

Could use Tracing and Monitoring along with FDMonitor. 

Ref:

https://docwiki.embarcadero.com/RADStudio/Athens/en/Tracing_and_Monitoring_(FireDAC)

https://docwiki.embarcadero.com/RADStudio/Athens/en/FDMonitor

 

FireDAC Monitor (FDMonitor) is an analog to BDE SQL Monitor and is a debugging tool for:

  • Tracing a communication between a FireDAC application and a Database Management System (DBMS).
  • Exploring details of commands, parameters, states, execution statistics, and so on.

 

Share this post


Link to post

I'm having trouble figuring out how to monitor an embedded SQLite database. FireDAC Monitor runs the program, but I see no traffic information.

Share this post


Link to post

1. Run FDMonitor (Delphi's main menu:  Tools -> FireDAC Monitor. Let it keep running. 

2. Drop a FDMoniRemoteClientLink1 on the form/datamodule that has the FDConnection and set it's Tracing property to true.

3. Double left click the FDConnection set it's MonitorBy property to Remote.

4. Run the program. 

  • Like 1

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×