|Subject||Re: [firebird-support] Firebird Event Names|
> >In a before update, insert, delete triggerNot entirely true. There are systems that register for dynamic
> >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.
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.
When the procedure is finished, it could raise event (as written
in the documentation) like this:
myval = 'FINISH_MY_PROC_' || EventID;
and the application could respond to the user with "bla bla
has finished" and un-register interest in the one-time-only
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL