--- In ib-support@y..., Bill Katelis <bill@s...> wrote:

> Platform: SCO Interbase 5.5
>
> Can SQLCODE 100 be trapped in an SP as follows ...
>
> WHEN SQLCODE 100 DO
> BEGIN
> ........
> END
>
> if so - I can't get it to work...

Bill, AFAIK every successfully performed statement set this system
global to 100, so it senseless to trap. I recall about 8 years ago,
being newbie in SQL world, I had some idea which "required" it, but
can't remember what it was. If you explain your aim, perhaps we can
discuss suitable solution.

Best regards, Alexander V.Nevsky.