Hi,

> I have a 'before insert' trigger which performs a validation that I
> also need to do in a 'before_update' trigger. Is there a way to
> instruct the trigger to fire on 'before insert' *and* 'before update'
> operations?
> Using FB 1.5

This was new in Firebird 1.5 -- check the "Release Notes"
on how to do it.

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