version 11.2 (Modified)
TRIGGER PROPERTIES (triggerLevel; dbEvent; tableNum; recordNum)
Parameter | Type | Description | |
triggerLevel | Number | Trigger execution cycle level | |
dbEvent | Number | Database event | |
tableNum | Number | Involved table number | |
recordNum | Number | Involved record number |
Description
The TRIGGER PROPERTIES command returns information about the trigger execution level you pass in triggerLevel. You use TRIGGER PROPERTIES in conjunction with Trigger level to perform different actions depending on the cascading of trigger execution levels. For more information, see the topic Cascading Triggers in the section Triggers.
If you pass a non-existing trigger execution level, the command returns 0 (zero) in all parameters.
The nature of the database event for the trigger execution level is returned in dbEvent. The following predefined constants are provided:
Constant | Type | Value |
On Saving New Record Event | Long Integer | 1 |
On Saving Existing Record Event | Long Integer | 2 |
On Deleting Record Event | Long Integer | 3 |
The table number and record number for the record involved by the database event for the trigger execution level are returned in tableNum and recordNum.
See Also
About Record Numbers, Database event, Trigger level, Triggers.