4.5.7 Trigger Points - When
The trigger point defines when the trigger should be called. A trigger may be called at many different points.
Before and After Open/Close file:
Before and after open/close triggers are invoked immediately before or after an attempt is made to open or close a (logical) file.
Before and After Read (Input):
Before read triggers are invoked immediately before an attempt is made to read a record from a file, and therefore have no access to information from that record. After read triggers are invoked just before the details are passed back to the invoking function
Before Insert, Update or Delete:
These before action triggers are invoked immediately before an attempt is made to insert a new record into a file, update an existing record in a file, or delete an existing record from a file.
After Insert, Update or Delete:
These after action triggers are invoked immediately after data manipulation attempts are made (as described above). The after update trigger has access to both the old and new contents of the record.
The trigger point is a very important consideration. When before action triggers are invoked, it is not guaranteed that the action will be successful. You must always consider possible failure.
Also See
Trigger Points in the