Hi,

> Firebird 1.5 introduces runtime exceptions. Is it possible to use them

inside

> 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
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com