EPUB | CHM | PDF

TPSQLMonitor.Events.OnSQL

Top Previous Next

Reports dynamic SQL activity on PostgreSQL applications.

Syntax:

type TSQLEvent = procedure (EventText: string;
                            EventTime: TDateTime) of object;
OnSQL: TSQLEvent;

Description:

Write an OnSQL event handler to report dynamic SQL activity on PostgreSQL applications.

      • EventText is the text of the SQL command that triggered this event. Beginning from version 2.2.1 contains elapsed time for each operation.
      • EventTime indicates the time when the command passed to or from the PostgreSQL server.

You must enable the TraceFlags in each TPSQLDatabase component to allow the SQL monitor to receive status information from each database connection.