How Do I: Benefit from the new SQL Timestamp feature in Microsoft Dynamics NAV 2016

The next video in my “How Do I” serie is published by Plataan and Microsoft.

This video is about the new SQL Timestamp feature in Microsoft Dynamics NAV 2016.
With this new feature you can determine records changes in a different way.

Before NAV2016 you need to use the “OnDatabase” triggers to get all the changes and store then in a Queue table.

Now we can use a SQL Timestamp field to get all changes since the last run.
It is no rocket science, just create a BigInteger field and turn on the “SQL Timestamp” property.

Enjoy and see you next time in another How Do I video.

2 thoughts on “How Do I: Benefit from the new SQL Timestamp feature in Microsoft Dynamics NAV 2016

  1. Stijn B. says:

    Hello,
    Very nice aproach for a comon requirement. But how can you handle “deletes” in this model? Since the record no longer exists, hence the timestamp of the deleted record also disapeared?
    Thanks!

    1. Punky says:

      When you delete an object the total of all timestamps will also change. So the model will know that something has changed in the object table.
      Which objects must be checked in a separate table where all objects with timestamps are stored.

Leave a Reply

Your email address will not be published. Required fields are marked *