If you are not worried about performance (timewise) of this operation it
sounds like it should do the job.

Jason

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


Hi Jason, thanks for your time.

I'm going through a similar way. I created a table on db to do the log.

On OnStatement, I insert a row, and inform pk, date, time, sqlstatement and
result (this last one I set as 'OK'), also, I store pk in IB_Script.tag. If
OnError is triggered, I do an update and set the collumns: errorresult with
ErrorMessage, and change the result to 'ERROR' for the PK that is stored in
IB_Script.tag.

What do you (and others) think about this? Should it work properly? The
tests I did here was everything ok.

[]
Andrei