Subject RE: [firebird-support] Runtime exception - how to?
Author Si Carter
Hi Marcin,

> -----Original Message-----
> Firebird 1.5 introduces runtime exceptions. Is it possible to
> use them inside triggers?. If so can some show how to do it.

CREATE EXCEPTION EXC_CUSTOMERROR 'Custom Error';

COMMIT;

SET TERM ^ ;

CREATE TRIGGER TR_RAISE_EXCEPTION FOR FOO
ACTIVE BEFORE DELETE POSITION 0
AS
BEGIN
EXCEPTION EXC_CUSTOMERROR;
END^

SET TERM ; ^

Hih

Si Carter
http://www.fbtalk.net/
http://www.tectsoft.net/