Causes an application to wait until notified of an event occurrence. Available in
EVENT WAIT request_name;
Application event handle declared in a previous
EVENT WAIT is the second step in the InterBase two-part synchronous event mechanism. After a program registers interest in an event,
EVENT WAIT causes the process running the application to sleep until the event of interest occurs.
Examples: The following embedded SQL statements register an application event name and indicate the program is ready to receive notification when the event occurs:
EXEC SQL EVENT INIT ORDER_WAIT EMPDB ('new_order'); EXEC SQL EVENT WAIT ORDER_WAIT;