TRIGGER PROPERTIES
TRIGGER PROPERTIES ( triggerLevel ; dbEvent ; tableNum ; recordNum )
| Parameter | Type | Description | |
|---|---|---|---|
| triggerLevel | Integer | → | Trigger execution cycle level |
| dbEvent | Integer | ← | Database event |
| tableNum | Integer | ← | Involved table number |
| recordNum | Integer | ← | Involved record number |
Description
The TRIGGER PROPERTIES command returns information about the trigger execution level you pass in triggerLevel. You use this command in conjunction with Trigger level to perform different actions depending on the cascading of trigger execution levels. For more information, see 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 in the Trigger Events theme:
| Constant | Type | Value |
|---|---|---|
| On Deleting Record Event | Integer | 3 |
| On Saving Existing Record Event | Integer | 2 |
| On Saving New Record Event | Integer | 1 |
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
Trigger event
Trigger level
Triggers
Properties
| Command number | 399 |
| Thread safe | ✓ |