TRIGGER PROPERTIES

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 11.2 (Modified)


TRIGGER PROPERTIES (triggerLevel; dbEvent; tableNum; recordNum)

ParameterTypeDescription
triggerLevelNumberTrigger execution cycle level
dbEventNumberDatabase event
tableNumNumberInvolved table number
recordNumNumberInvolved 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:

ConstantTypeValue
On Saving New Record EventLong Integer1
On Saving Existing Record EventLong Integer2
On Deleting Record EventLong Integer3

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.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next