At 12:49 PM 12-06-01 +0200, Ivan Prenosil wrote:

>If you do not need to handle exceptions inside SP (like in your example)
>just do not trap them (i.e. do not use WHEN ANY DO).
>
>Possible errors/exceptions will be reported back to client software
>through status vector
>(iirc in Delphi components there should be OnError event with SQLCODE parameter).

In IB Objects components the OnError event gives you not only SQLCode but the text of the associated error; *and* you can customize the message that the user sees, too.

Cheers,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________