O'Reilly logo

Extending Microsoft Dynamics NAV 2016 Cookbook by Alexander Drogin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding database triggers

Data in the database is constantly changed - records are inserted, updated, deleted. Almost any user action results in data modification, and all modifications of data run application triggers.

How to do it...

In this recipe we will learn how to use some of the most important and frequently used table triggers to control data flow.

  1. Open table 50010 Item Certificate in object designer. Click C/AL Code in the View menu or press F9 to open table code. Open C/AL Globals and create two functions, DeleteCertificateActions and UpdateItemOnActions.
  2. Position cursor in the DeleteCertificateActions variable and declare a local record variable ItemCertificateAction:

    Name

    DataType

    Subtype

    ItemCertificateAction

    Record ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required