Subject Re: [IBO] Debugging scripts
Author Marco Lauria
At 22.28 22/08/2001 +0200, you wrote:
>Hi!
>
>I have a huge DDL script (TIB_Script). I reordered some things, and now it
>returns an error message, to the effect, "error error blah error foreign key
>error preserve data integrity error error trigger". No line number. No table
>name ;=(
>
>How on earth could I know what line of the script, or which table definition
>causes this error?
Hello,
you should catch the OnError Event of the TIB_Script
so that you'll get the SQL String that is causing the error.
Also in order to trace which statement you are executing you can use the
OnStatement Event.
Regards
Marco