8. OpenSQL Statements : INQUIRE_SQL : Inquiring About Database Events
 
Share this page                  
Inquiring About Database Events
The following table lists the INQUIRE_SQL parameters that return information about a database event. All character values are returned in lower case. If no event is queued, an empty or blank string is returned (depending on your host language conventions).
Object
Data Type
Description
dbeventname
Character
The name of the event (assigned using the CREATE DBEVENT statement). The receiving variable must be large enough for the full event name; if the receiving variable is too small, the event name is truncated to fit.
dbeventowner
Character
The creator of the event.
dbeventdatabase
Character
The database in which the event was raised.
dbeventtime
Date
The date and time at which the event was raised.
dbeventtext
Character
The text (if any) specified as the event_text parameter when the event was raised. The receiving value must be a 256-character string; if the receiving variable is too small, the text is truncated to fit.