Thomas,

> > > 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.

Not useful either :-)

How would I register for an event that I don't know will occur? (change
name to Steinmaurer ;) ....


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com