During development I always trace all communication from my application to the database. It helps a lot to see what and when commands are sent to the database.
DA’s DriverManager (TDADriverManager) provides a very simple way to trace communication between your application and the database in runtime. Just set the TraceActive property to True, select what detail level you want in the TraceFlags property and provide a handler to the OnTraceEvent event.
You can then log the messages the way you prefer. I use the GExperts Debug Window for this purpose.
