One way I suppose would be to only feed your log the previous CurrentSQL
when OnStatement is called and then to take the last statement from
OnStatement in the AfterExecute event.

Jason Wharton

----- Original Message -----
From: "Andrei Luís" <compuvale.software@...>
To: <ibobjects@yahoogroups.com>
Sent: Friday, July 31, 2009 12:52 PM
Subject: [IBO] TIB_Script


> Hello,
>
> I'm trying to use TIB_Script, to run sql statements when my application
> starts.
>
> The idea is to check the exist of a txt file (that contains one or more
> sql
> statements), load it in tib_script.sql and run it. OK, that is running
> well.
>
> Now, I want to implement a log for these sql statements executions. As I
> can
> see, AfterExecute is called after the whole script is executed.
> OnStatement
> is called before the execution, here I can acess CurrentSQL, and see what
> statement will be executed, but I don't know if it's well executed.
> OnError
> is triggered when the statement execution returns an error, but how can I
> know that the statement has no errors?
>
> []s
> Andrei
>
> Win XP Pro + Delphi 2006 Pro + FB 2.1.2 + IBO 4.8.7