EVENT INIT
Go Up to Statement and Function Reference (Language Reference Guide)
Registers interest in one or more events with the InterBase event manager. Available in gpre.
EVENT INIT request_name [dbhandle]
[('string' | :variable [, 'string' | :variable …]);
| Argument | Description |
|---|---|
|
<request_name> |
Application event handle |
|
<dbhandle> |
Specifies the database to examine for occurrences of the events; if omitted, <dbhandle> defaults to the database named in the most recent |
|
‘<string>’ |
Unique name identifying an event associated with <event_name>. |
|
Host-language character array containing a list of event names to associate with. |
Description: EVENT INIT is the first step in the InterBase two-part synchronous event mechanism:
EVENT INITregisters an application interest in an event.EVENT WAITcauses the application to wait until notified of the event occurrence.
EVENT INIT registers an application interest in a list of events in parentheses. The list should correspond to events posted by stored procedures or triggers in the database. If an application registers interest in multiple events with a single EVENT INIT, then when one of those events occurs, the application must determine which event occurred.
Events are posted by a POST_EVENT call within a stored procedure or trigger.
The event manager keeps track of events of interest. At commit time, when an event occurs, the event manager notifies interested applications.
Example: The following embedded SQL statement registers interest in an event:
EXEC SQL
EVENT INIT ORDER_WAIT EMPDB ('new_order');