> >> >In a before update, insert, delete trigger
> >> >it is possible to do
> >> >POST EVENT new.field_name
> >> >to post an event with the data contained in the field.
> >>
> >> No; events don't carry any data. They are merely named signals.
>
> > Not entirely true. There are systems that register for dynamic
> > events. For example, imagine a server side process (stored
> > procedure) that takes a few minutes to finish.
>
> > An application can fire off a thread that starts the procedure
> > with an application defined parameter (eg: event_id) and
> > register an event "FINISH_MY_PROC_9988332" where
> > "9988332" is the event ID.
>
> But, the original question was if it is possible to use events in this
> manner: POST_EVENT 'event name' new.field_name
>
> THAT is not possible. Sending data, which the application might not
> know, via events. Essentially, pushing the new data to the
> application.

No, you have to have registered interest in the event. That is true.

Wild-card registering events was on the wishlist someday though.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com