tobenschain 0 Posted Wednesday at 11:20 PM 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
Brian Evans 130 Posted Wednesday at 11:39 PM 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
tobenschain 0 Posted 5 hours ago 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
Brian Evans 130 Posted 4 hours ago 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. 1 Share this post Link to post