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 …
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 …
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 »
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 »
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 …
Last summer, when I posted my first article I though blogging is very easy, and I’ll post an article every week. Actually, it’s not that easy. Anyway, after few months here is the article, I promised: a 100% generic web service client for NAV. I was looking for a way to automate all my web …