Skip to main content
Version: Next

TRIGGER PROPERTIES

TRIGGER PROPERTIES ( triggerLevel ; dbEvent ; tableNum ; recordNum )

ParameterTypeDescription
triggerLevelLongint🡒Trigger execution cycle level
dbEventLongint🡘Database event
tableNumLongint🡘Involved table number
recordNumLongint🡘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:

ConstantTypeValue
On Deleting Record EventLongint3
On Saving Existing Record EventLongint2
On Saving New Record EventLongint1

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