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 20 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 18 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
tobenschain 0 Posted 8 hours ago This is my properties step one runs the program Share this post Link to post
Cristian Peța 122 Posted 7 hours ago 19 minutes ago, tobenschain said: This is my properties Why? It should be like this: Share this post Link to post
tobenschain 0 Posted 7 hours ago The FDConnection is a variable BudSys_Con: TFDConnection; BudSys_Con := TFDConnection.Create(nil); Share this post Link to post
Cristian Peța 122 Posted 7 hours ago (edited) 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 6 hours ago by Cristian Peța Share this post Link to post
Cristian Peța 122 Posted 6 hours ago FireDAC Monitor has nothing to do with forms. It receives data from FDConnection. Share this post Link to post
Brian Evans 130 Posted 5 hours ago 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? Share this post Link to post