Problem: Use the TIBSQLMonitor component to monitor the dynamic SQL that passes through the InterBase server. You can write an application that can view only its own SQL statements, or you can write a generic SQL monitor application that monitors the dynamic SQL of all applications built with InterBase Express (IBX). Use the TIBSQLMonitor component to watch dynamic SQL taking place in all InterBase data access applications both before and after they have been compiled. Solution: To build a simple SQL monitoring application, follow these steps: 1. Open a new form in Delphi. 2. Add a Memo component to the form and clear the Lines property. 3. Add a TIBSQLMonitor component to the form 4. Double-click the OnSQL event and add the following line of code: Memo1.Lines.Add(EventText); 5. Compile the application. You can now start another IBX application and monitor the code.
Last Modified: 19-OCT-00