Since v2.6.0

Extended version of OnBatchError event. OnBatchErrorEx event fires after an error occurs after execution of SQL statement from SQL script executed by ExecSQL() method.

Syntax:

OnBatchErrorEx: TMySQLBatchErrorExEvent;
type
TMySQLBatchErrorExEvent = procedure(Sender : TObject;
                                         E : EMySQLDatabaseError;
                                   SQLText : String;
                               StatementNo : Integer;
                               var aAction : TmySQLBatchAction) of object;

Description:

Use this event if you want to add some custom error processing. For example to ask user if he wants to continue. You can set aAction param value to baIgnore if user's answer is YES or to baAbort otherwise.

Take a look at Action property for possible aAction parameter values

Parameters:

Sender

Points to TMySQLBatchExecute component generated this error;

E

An instance of EmySQLDatabaseError object which contains this error info;

SQLText

Contains the text of the statement in which this error occurs;

StatementNo

The number of the SQL statement in SQL script.

aAction

Allows to override default error action defined with Action property for current statement.