> > Hi! > > > > I wonder, is there a documentation of the various > > RDB$TRIGGERS.RDB$TRIGGER_TYPE values somewhere? The Interbase 6 > > documentation (Language Reference, specifically) lists the values for > > the regular BEFORE/AFTER INSERT/UPDATE/DELETE, but I can't find values > > for multi-event triggers, e.g. BEFORE INSERT OR UPDATE. Is there a > > better way to find them than to create all possible trigger types and > > see what appears in RDB$TRIGGERS? > > > > (I am using these values to translate a database structure to a > > human-readable form. But even for this limited purpose, I would feel > > more comfortable with the documented values than experimentally > obtained.) > > Take a look at the content of RDB$TYPES.
I didn't remember about this table! Thanks! Unfortunately, it only lists the normal (single-action) triggers and the database-level triggers. At least in all my databases (ranging from FB 1.5 to FB 2.5). Josef