Subject Re: [firebird-support] Runtime exception - how to?
Author Martijn Tonies

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

Firebird always had exceptions. Firebird 1.5 introduces the ability to
change the actual message.

First, you create an EXCEPTION object:

CREATE EXCEPTION myexception 'message'

Next, you can use your exception in a procedure/trigger like this:

exception myexception;

or, change it's message:

exception myexception 'test';

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!