POST EVENT

From InterBase

Go Up to Procedures and Triggers


Posts an event. Available in triggers and stored procedures.

POST_EVENT 'event_name' | <col | variable>;
Argument Description

<event_name>

Name of the event being posted; must be enclosed in quotes

col

Name of a column whose value the posting will be based on

variable

Name of a string variable in the stored procedure or trigger

Description: POST_EVENT posts an event to the event manager. When an event occurs, this statement will notify the event manager, which alerts applications waiting for the named event.

Example: The following statement posts an event named “new_order”:

POST_EVENT 'new_order';

The next statement posts an event based on the current value of a column:

POST_EVENT NEW.COMPANY;

The next statement posts an event based on a string variable previously declared:

myval = 'new_order:' || NEW.COMPANY;
POST_EVENT myval;

See Also

For more information on events, see the Embedded SQL Guide.

Advance To: