C/AL

How to: Access timestamp from C/AL

How to access timestamp from C/AL? When you Google/Bing this question, you mainly get three answers: Short answer: you can’t, Write a SQL query using ADO.NET, Create a SQL view and use a linked table on NAV When Microsoft introduced NAV 2016, we got a fourth answer described in this blog post by Dynamics NAV …

How to: Access timestamp from C/AL Read More »

How to calculate Dimension Set ID

Starting from Dynamics NAV 2013, dimension’s structure has changed a lot. Since then, a lot of developers struggle to insert or update dimensions pragmatically. I will not bother you with what was already explained a hundred times in other blogs on how to calculate Dimension Set ID. Better, I will share with you a simple …

How to calculate Dimension Set ID Read More »

Text encoding in NAV 2009 R2 Classic Client – Part 2

As I already explained in this blog post you can import text files with encoding in Dynamics NAV 2009 R2 Classic Client and old versions. Today, I will use the same trick to export a text file with encoding (UTF-8 in the example below). To illustrate this, let’s export all items in a text file …

Text encoding in NAV 2009 R2 Classic Client – Part 2 Read More »

Text encoding in NAV 2009 R2 Classic Client – Part 1

P.S: If you’re still using Microsoft Dynamics NAV 2009 R2 Classic Client or a previous version, then you may want to continue reading this blog post. We all know that Microsoft Dynamics NAV 2009 R2 Classis Client supports ANSI only (code page 1252 or depends on your windows localization). In order to import/export encoded files …

Text encoding in NAV 2009 R2 Classic Client – Part 1 Read More »

My two cents about Try/Catch in C/AL

By introducing NAV 2016, Microsoft introduced Try Functions to endow developers with some sort of Try/Catch in C/AL. The purpose of this blog is not to add another entry to explain how to use Try Functions. José Castro Fernández has already explained this here. The problem with these types of functions is resumed in this sentence …

My two cents about Try/Catch in C/AL Read More »

Scroll to Top