How Many Entries Are Passed in the TRIG_LIST?
When a trigger is invoked it is passed a working list called TRIG_LIST that contains details of the field or table record that is being actioned.
When invoked, TRIG_LIST may contain 0, 1 or 2 entries:
| Number of Entries
|
Meaning / Content
|
|
0
|
There are no details available in this context (e.g.: before open, before read).
|
|
1
|
There is one set of details available in the current context (e.g.: after read).
|
|
2
|
There are two sets of details available in the current context. Entry 1 is the new details and entry 2 is the previous details. (e.g.: before/after update images).
|
|
The number of entries passed in the list varies with the operation in progress according to the following table:
| Operation In Progress
|
Number Of Entries In TRIG_LIST
|
|
Before Open
|
0
|
|
After Open
|
0
|
|
Before Close
|
0
|
|
After Close
|
0
|
|
Before Read
|
0
|
|
After Read
|
1
|
|
Before Insert
|
1
|
|
After Insert
|
1
|
|
Before Update
|
2
|
|
After Update
|
2
|
|
Before Delete
|
1
|
|
After Delete
|
1
|
|
