Hi Martijn,

> > So you have these alternatives:
> >
> > POST_EVENT 'AccountAdded' ;
> >
> > or
> >
> > POST_EVENT NEW."AccID" ;
> > (Note: double quotes used only if you defined "AccID" in the database
> > using double quotes)
> >
> > or
> > declare variable StringVar varchar(40);
> > ...
> > StringVar = 'New account added: ' || cast (new."AccID" as char(10)) ;
> > POST_EVENT StringVar;
>
> How do you register for such an event?
> (also for the NEW.ACCID event?)

Only by the event name, and for the two examples above, it
doesn't really seems to be practicable, from a clients
application POV.

Though, e.g. POST_EVENT NEW.LASTNAME might be useful, if you
want to be notified, when the lastname was changed to e.g.
'Steinmaurer', because that's the event name your client
application is listening.



--
Best Regards,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com