At 10:55 PM 11/02/2005 +0000, you wrote:

>--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...>
>wrote:
> >
> > Yes, it returns an exception
> >
> > Your main SP can handle (swallow or re-raise) that exception if
>you
> > like. The same way that delphi and I'm sure many other languages
> > handle them.
> >
> > Adam
>
>Hi,
>
>U don't understand i think. I need the EXACT messagetext which
>occurred in SP2 in SP1 to insert in a log. I can't insert in the log
>in SP2 because all changes will b undone by the triggered exception.

That's why you should use an external table for logging if you want the log
to survive an unhandled exception. Writes to an external table don't get
undone by a rollback.

./hb