Tag: Development

Delete all records in table with C/AL – Truncate

Edited: added a “warnings” section below Did you ever have to empty a certain table entirely in NAV? Well, I admit, you don’t need to do this too often. And definitely not in a repetitive way. Well, I came across a situation where I needed to delete all millions of records from a table every …

Continue reading

Permanent link to this article: https://www.waldo.be/2016/06/30/delete-all-records-in-table-with-cal-truncate/

NAV Upgrade: Import and Compile crashes when NST is running

This is just a small blogpost to mention a few things you need to take into account when you’re working with objects on a large scale – I mean importing, exporting, upgrading, compiling, .. whatever. My scenario I was upgrading a customer from CU3 to CU8. Sure, you might wonder why it took me so …

Continue reading

Permanent link to this article: https://www.waldo.be/2016/06/16/nav-upgrade-import-and-compile-crashes-when-nst-is-running/

Invoke-NAVSQL: Execute SQL queries on NAV databases with PowerShell

Just another CmdLet to bother you with (no really, it’s quite an interesting one – try to keep awake … ;-)). The more you use PowerShell .. and the more you use it for NAV .. you just realize that you have to call out to SQL Server quite regularly. Just a few examples: Backup …

Continue reading

Permanent link to this article: https://www.waldo.be/2016/06/08/invoke-navsql-execute-sql-queries-on-nav-databases-with-powershell/

NAV 2016: All Published Events

Blogging has been low lately. I have been insanely busy with providing content for the Cloud SureStep for Product Development on the DLP, which means: less free time :(. But .. Together with a brilliant colleague, I’m also working on an internal project: A code analyzer in PowerShell. Why in PowerShell .. well .. because …

Continue reading

Permanent link to this article: https://www.waldo.be/2016/05/30/nav-2016-all-published-events/

Apply-NAVDelta to add and remove customizations

Yep, PowerShell again. So the people that deny PowerShell can stop reading now :-). Although I do think this is quite an interesting blogpost on how to work somewhat more easily with deltas, by the use of a function that is part of my PowerShell Module, called: Apply-NAVDelta. I was actually just thinking after my …

Continue reading

Permanent link to this article: https://www.waldo.be/2016/03/16/apply-navdelta-to-add-and-remove-customizations/

Export NAV Application Objects

When working with NAV, you’re familiar of working with objects. And nowadays, we have quite a lot of options, like: Fob file Text file Split text files Delta’s Reverse Delta’s … (more?) Depending on the situation, you might be interested in one of these kinds of exports – if not all. Now, I have been …

Continue reading

Permanent link to this article: https://www.waldo.be/2016/03/11/export-nav-application-objects/

Remove customizations with (Reverse) Deltas

I’m going to explain you a concept that is so simple that you’re probably going to react like: “dude .. come on .. you just totally wasted my time .. this is so obvious.. can’t believe you just don’t take this for granted”. But I’m still gonna. Just because of the fact that the concept …

Continue reading

Permanent link to this article: https://www.waldo.be/2016/03/07/remove-customizations-with-reverse-deltas/

Discovery Event Pattern

I have been working on describing this very interesting NAV Design Pattern that uses events. We have been implementing it a few times, and I just didn’t want to hold it from you. You can find the pattern on “The Microsoft Dynamics NAV Design Patterns Wiki“. The actual design pattern can be found here, but …

Continue reading

Permanent link to this article: https://www.waldo.be/2016/03/02/discovery-event-pattern/

NAV 2016: Hooks or Events?

You don’t get the chance to blog on the 29th of February too much. In fact, you only get one chance in 1461 days .. . So let’s take this opportunity, to bother you with something that I have been thinking about from the moment Microsoft Dynamics NAV 2016 was release: What do we do …

Continue reading

Permanent link to this article: https://www.waldo.be/2016/02/29/nav-2016-hooks-or-events/

NAV 2016 Extension Development Shell on the Azure Demo VM

Now, that’s a long title, isn’t it? 🙂 I was in a conversation with Freddy Kristiansen .. the so called “father” of the “Azure Demo VM Image for NAV 2016” (or how do you kids call it these days). If you haven’t heard about that, I strongly advise you to check out for example MVP …

Continue reading

Permanent link to this article: https://www.waldo.be/2016/02/25/nav-2016-extension-development-shell-on-the-azure-demo-vm/