How do I use the InterBase Express (IBX) SQL monitor?

By: Borland Staff

Abstract: Steps to build a simple SQL Monitor for InterBase Express

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.


Server Response from: ETNASC03