> > > I would like to know if someone knows of a way to get the SQL
> > > statement that caused a trigger to fire?
> >
> > You cannot, you can only know if it's an insert, delete or update
> > statement.
> >
> Are you sure there is absolutely no way? But please do share how to

As far as I know, yes.

> know if it's an insert, delete or update please.

IF (DELETING)

(INSERTING)

(UPDATING)

See the Firebird 1.5 release notes.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com