Debugging an InterBase Application | C++Builder 5 Developers Guide

In addition to the normal collection of forms and controls that the application might have, this application must work with the InterBase server. This includes providing connection information, starting transactions, executing search requests , and obtaining any other information the client requires.

Many activities are the responsibility of the database server, which can make it difficult to debug them from the C++Builder IDE. To view these activities, IBExpress supplies the TIBSQLMonitor component. This is a component that generates an event for every InterBase activity that occurs. Events of interest should be specified in the TraceFlags property of the TIBDatabase to which the TIBSQLMonitor component is linked. If we take the information supplied in the generated event and add it to a TMemo , we have a powerful tool for determining which InterBase activities occurred and in what order. Although seemingly cryptic at times, this information can help solve problems involving sequential interactions between multiple transactions and queries.

Top