Trigger
Property keys mapped to the columns of the OpenEdge SQL `SYSTRIGGER` system catalog table.
SYSTRIGGER contains one row for each trigger defined on a table.
Tags
Table of Contents
Constants
- EVENT : string = 'event'
- Trigger event: `I` (INSERT), `U` (UPDATE) or `D` (DELETE) (`event`).
- FOR_EACH : string = 'forEach'
- Granularity flag: `R` (FOR EACH ROW) or `S` (FOR EACH STATEMENT) (`for_each`).
- TIMING : string = 'timing'
- Trigger timing: `B` (BEFORE) or `A` (AFTER) (`when`).
- TRIGGER_OWNER : string = 'triggerOwner'
- Owner (SQL schema) of the trigger (`trigowner`).
- TRIGGER_TEXT : string = 'triggerText'
- SQL source text of the trigger body (`trigtext`).
Constants
EVENT
Trigger event: `I` (INSERT), `U` (UPDATE) or `D` (DELETE) (`event`).
public
string
EVENT
= 'event'
FOR_EACH
Granularity flag: `R` (FOR EACH ROW) or `S` (FOR EACH STATEMENT) (`for_each`).
public
string
FOR_EACH
= 'forEach'
TIMING
Trigger timing: `B` (BEFORE) or `A` (AFTER) (`when`).
public
string
TIMING
= 'timing'
TRIGGER_OWNER
Owner (SQL schema) of the trigger (`trigowner`).
public
string
TRIGGER_OWNER
= 'triggerOwner'
TRIGGER_TEXT
SQL source text of the trigger body (`trigtext`).
public
string
TRIGGER_TEXT
= 'triggerText'