Types of Triggers

There are two types of triggers in X/E:

• Default Trigger: A Default Trigger is specified in the database table as the (write/delete) triggers. These triggers follow the naming convention as YYYYtwrite.p and YYYYtdelete.p.

  Here the ‘YYYY’: indicates the first 4 characters of DB table.

• Logical Trigger: A Logical Trigger is used when some additional tasks need to be performed during data insertion and deletion. These additional tasks may include anything that might need to be performed during database updates. The task put in logical trigger can be both application and developer dependent. Some of these tasks include:

– Maintaining referential integrity during delete and update.
– Maintaining the transactions in Javra IDE.
– Validating data during writes.