Subject | Values of RDB$TRIGGERS.RDB$TRIGGER_TYPE |
---|---|
Author | Josef Kokeš |
Post date | 2013-03-22T14:44:23Z |
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.)
Thank you,
Josef
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.)
Thank you,
Josef