BEM Trigger List MXF2

This screen allows you to list the Database triggers for any Custom BEM Event.

Opens from System Controls BEM Trigger List.

Click Insert and BEM Trigger Edit MXF3 opens.
Select the entry you want to edit, click Amend and BEM Trigger Edit MXF3 opens.

To create an BEM Trigger you must create the necessary SQL expression from the allowed before and after base table column values.

Actions

Only when an Event is set up in the Action List can the given Handler Program(s) be triggered. If there are no entries in the Action List for an Event then no extra processing will occur when the Event occurs.

Options

Action	Use
Edit Recreate	Click Edit: Recreate to transfer to the BEM Trigger Edit MXF3, then using the Update action would recreate the DB Trigger.
Edit Drop	Click Edit: Drop to transfer to the BEM Trigger MXF3, then using the Update action would Drop the DB Trigger.

Fields

Field	Description
Name	Display Only. This is a generated 8 character value. Shipped Object Event Actions start with "SYS" followed by their 3 digit system reference number follow by a two digit sequence number and User defined ones will start with "BEM".
Web Service Include Cmpy/ Web Service Include / Web Service Include Description	These are the generated Web Service Export DB BEM Trigger SQL stored in the referenced QED Include. The Include Description indicates which Table the DB Trigger is for.

You can change the appearance of the list view:

If not described in this topic, click on a field and press F1 to view help. See Common Fields for more information.

Fast prompt allows you to quickly view a list of options for certain fields.

NOTE Field visibility can be defined by your System Administrator, so not all fields documented may be shown.

See Using the Command Line on opening the screen without going through the menu.