Using database trigger events

Database trigger events give the C/AL developers the possibility to receive notifications when data in a table is being updated. There are eight events raised on data modification - before and after each of the four table actions: insert, modify, delete, and rename. Two more events are reserved for field validation - OnBeforeValidateEvent and OnAfterValidateEvent.

Unlike business and integration events, database triggers are not raised by the application code, they are managed by the NAV server.

How to do it...

In the following recipe, you will create an event subscriber function that subscribes to database trigger events to implement additional verification of the record before it is inserted into the database.

1. In the NAV codeunit designer, create a new codeunit with ID 50902 and name Database Trigger Event.
2. In C/AL Globals, declare a function OnInsertVerifyRecord that will subscribe to the OnInsert event of the Customer table.
3. Open the function properties. In the...