Hi Milan,

> I read the IB6 docs, and see that type of trigger is held in
> rdb$triggers system table, in rdb$trigger_type variable
>
> RDB$TRIGGER_TYPE
> The type of trigger being defined
>
> Values are:
> 1 - BEFORE INSERT
> 2 - AFTER INSERT
> 3 - BEFORE UPDATE
> 4 - AFTER UPDATE
> 5 - BEFORE DELETE
> 6 - AFTER DELETE
>
> Since FB 1.5 introduces trigger that can be combinations of these, I'd
> like to know if information is still in this field? And what are the
> values? (I guess I can find it out by creating all types of triggers and
> reading, but I want to be sure I'm reading the right field).
>
> I apologize if it is in release notes, but I couldn't find it.

Have a look in %Firebird%\doc\sql.extensions\README.universal_triggers


HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com