The "Triggers" option allows to define triggers to automatically run a stored procedure when a table event occurs.
Save - commits any changes made since the last save
Save with "NOCHECK" - commits any changes made since the last save, and does not update references to views, tables, and columns in forms, reports, labels, access rights, and rules. In this case, the user assumes the responsibility to update any references to views, tables, and columns in forms, reports, labels, access rights, and rules.
Help - opens the Data Designer Help
Save and Close - commits any changes made since the last save and closes the Data Designer module
Save and Close with "NOCHECK" - commits any changes made since the last save, closes the Data Designer module, and does not update references to views, tables, and columns in forms, reports, labels, access rights, and rules. In this case, the user assumes the responsibility to update any references to views, tables, and columns in forms, reports, labels, access rights, and rules.
Close - closes the Data Designer module. If unsaved changes have been made, you will be prompted to save them before closing. |
|
There are "Before" triggers and "After" triggers which identify the time of execution of the trigger. A trigger can be set to automatically run a stored procedure before and/or after an update, delete, or insert event occurs in a table.
To enable a specific trigger, select the "Execute" check box for the appropriate trigger type. After doing so, an existing stored procedure can be selected. The button on the far right is available to review and edit the selected stored procedure code.
Before Insert - executes the specified stored procedure before a row is inserted
After Insert - executes the specified stored procedure after a row is inserted
Before Update - executes the specified stored procedure before a row is updated
After Update - executes the specified stored procedure after a row is updated
Before Delete - executes the specified stored procedure before a row is deleted
After Delete - executes the specified stored procedure after a row is deleted
See Also:
Stored Procedures
