Reports dynamic SQL activity on MySQL applications.

Syntax:

type TSQLEvent = procedure(const Application, Database, Msg, SQL, ErrorMsg: string;
    DataType: TMySQLTraceFlag; const ExecutedOK: boolean; EventTime: TDateTime) of object;
OnSQL: TSQLEvent;

Description:

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

Application

Owner application name;

Database

If SQL is executed within a specific database, this parameter indicates its name;

Msg

This parameter indicates the type of the executed operation as string - CONNECT, DISCONNECT, EXECUTE, FETCH, etc.;

SQL

This parameter contains full executed SQL statement, if such is available;

ErrorMsg

If statement executed with error, this parameter returns the error message, otherwise it is empty;

DataType

This parameter indicates the type of the executed operation as enumerated data;

ExecutedOK

This parameter indicates if operation execution succeeded;

EventTime

Indicates the time when the command passed to or from the MySQL server.