On 2 Jun 2006 at 9:12, Dmitry Yemanov wrote:

>tracker. But I'm not sure I like the term "trigger" in this context.
>Such an object has enough semantical differences from a regular
>trigger. It doesn't have OLD/NEW contexts, it doesn't make sense to
>have before connect/after disconnect triggers, etc.

Not sure about before connect, but OLD and NEW contexts could be
useful if they include connection params.
Consider these examples:

IF(OLD.ROLE = 'NONE') THEN
NEW.ROLE = 'SIMPLE_USER';

SELECT RDB$CHARSET FROM RDB$DATABASE INTO :NEW.CHARSET;

--
SY, Dimitry Sibiryakov.