FireDAC generated SQL

[tobenschain 0]

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?

[Brian Evans 130]

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.

 

[tobenschain 0]

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

[Brian Evans 130]

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. 

[tobenschain 0]

This is my properties 

 

step one runs the program 

[Cristian Peța 122]

19 minutes ago, tobenschain said:

This is my properties 

Why?

It should be like this:

[tobenschain 0]

The FDConnection is a variable

 

BudSys_Con: TFDConnection;

 

BudSys_Con := TFDConnection.Create(nil);

 

[Cristian Peța 122]

15 minutes ago, tobenschain said:

The FDConnection is a variable

Yes, no problem. And what has this to do with FireDAC Monitor tool properties?

BTW, you can start yourself the Monitor from the Bin folder, not necessary to use the link from the IDE.

Edited 4 hours ago by Cristian Peța

[tobenschain 0]

It is not on a form.

[Cristian Peța 122]

FireDAC Monitor has nothing to do with forms. It receives data from FDConnection.

[Brian Evans 130]

The tools entry for FireDAC Monitor is just an easy way to run the program it has no relation to anything loaded in the IDE like a project or something being debugged. Not sure why you messed with the settings for it to run something else. 

 

If you know how to dynamically instance a FDConnection surely you know how to do the same for a FDMoniRemoteClientLink and set some properties to link everything up and turn tracing on?