How Do I: Easily Connect to External Databases from CAL in Microsoft Dynamics NAV 2016

It seems that I have missed the publication of my “How Do I” video in April.
Normally when Plataan and Microsoft publishes a video on youtube it appears on the Dynamics NAV blog ( But for some reason this one not. But no worries it was already on youtube.

In this video I have covered the new way of connecting to External Database from CAL. Continue reading  

Get Source Table from Page

Codeunit 700 Page Management is a Codeunit that I use once in a while. It has functions to get the Default Lookup Page or the Card Page of a certain table.
It also contains functions to open a Page by only passing a Table ID or a Record. You can run it default or modal and even open a page with an autofocus on a certain table field if you like.

All these functions are very handy, but I only miss one.

In my solution I need to get the table of a certain Page ID. So the opposite way of the existing functions.
By looking to the existing functions you will see that there’s a way. Most of the functions are using a system table called “Table Metadata”, were you can easy find the “Lookup Page”.

But the function “GetDefaultCardPageID” also uses the table “Page Metadata”.
So lets take a closer look to this table.

Continue reading  

A TableSyncSetup value Copy for old table cannot be specified when no new table exists

When upgrading a old NAV database you sometimes need to transfer data to new tables. With the Upgrade codeunits you can manage this easily.
First you make a TableSyncSetup function where you configure your transfer.
And then you make an UpgradePerCompany or UpgradePerDatabase function where you will do the actual transfer.

But recently I got the following strange error when deleting a table.

The system tells me that there doesn’t exists a new table???? Continue reading  

Vote: Rename Event Parameters

This week I started to transform some OnAfter and OnBefore Hooks on tables to Events.
When performing these manuel steps I first though about Upgradeability. Every modification must be upgraded smoothly without any manual handling afterwards.
So what will the result be if I upgrade a customer with the Hook triggers? I tested with a simple example. Continue reading  

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. Continue reading