Active Query Builder support area

How to turn the internal logging on? (VCL Edition)

Last modified:

To investigate the reason for malfunction or slow metadata loading, you can turn the internal logging on. Below is the sample code for doing so:

var logger: IacLogger;
    logger := TacFileLogger.Create(logFileName);

    // log queryBuilder events (setting SQL, UI actions, ...)
    queryBuilder.Logger := logger;
    // log syntaxProvider events (server version detection, metadata loading, ...)
    queryBuilder.SyntaxProvider.Logger := logger;
    // log metadataProvider events (query execution, driver calls, ...)
    queryBuilder.MetadataProvider.Logger := logger;

Is this article helpful for you?