Final Posting on the NAV Sustained Engineering Team Blog

We’re combining the NAV Sustained Engineering Blog with the NAV Team Blog, and will no longer be posting on the SE blog. You can follow our future posts on the NAV Team Blog. Also, the posts from the SE blog have been copied to the NAV team blog.

0

Setting Up a Mail Template for Document Approval Notifications

The email notifications that are sent between users according to the document approvals setup are based on email templates defining which fields and text to show in the notification.   The email template is an HTML file that you can export from Microsoft Dynamics NAV, edit in Word, for example, and then import back to…


Disable UAC if you are doing a technical upgrade from the same machine where SQL is hosted.

When doing a technical upgrade running Microsoft Dynamics NAV CSIDE client on the same machine as your SQL server, please run the CSIDE client with either UAC turned off or with full administrator rights (Run as administrator). The reason why this is important is because, when connecting locally from a Vista/Windows 2008 server to SQL…


How do Record Links encode their data in SQL server?

Recently I was asked about the encoding that it is done for record links in SQL. If you are not familiar with Record Links, which have been available since NAV version 5.0, just open any Card or List and then click Edit -> Links (Ctrl + L). “Record Links enable users to add links to…


SPN name Changes

It should be a common installation scenario to have NAV 2009 components installed on three different machines, one for the database hosted by SQL Server, one for the Microsoft Dynamics NAV Server (middle tier server) and the corresponding client machines. This installation is explained in MSDN “How To: Set Up Delegation”, however, what I wanted…


Installing Business Notification with SQL Server 2008

We are glad to announce that compatibility between Business Notification and SQL Server 2008 is as of now verified and confirmed. Business Notification can run on SQL Server 2008 provided that the 2 following components are also installed:   –          SQL Server Notification Services 2005 –          SQL Server 2005 Service Pack 3.   Notification Services…

1

An almost exact decimal

Recently I was working with a very interesting case, involving Automation, and AL runtime. This involves the number of decimals that NAV supports; giving the sensation that rounding is done incorrectly. First, I would like to bring you your attention to Table 370 (Excel Buffer). This table provides a very simple way to read and…


Cursor Types

One of the changes in Microsoft Dynamics NAV version 5, was to change from primarily making use of Fast-Forward cursor types to Dynamic cursors. The same change was implemented in version 4 from build 26410, which is Version 4, SP3 Update6(940718) + KB950920. The change of cursor type can also mean a change in behaviour. With…


The COPYSTREAM “problem” for Sockets

I must say that since I started working in the integration area of NAV (from within NAV), I got very interested in the possibilities that it would bring to NAV developers. Back then, I presented a Web Server for the NAS using the Socket ComCom and since then I have seen how people have used…


The asymmetric stream

Since NAV’s Stream introduction, there has been confusion about when to use READ and when to use READTEXT; when to use WRITE and when WRITEXT. As it is documented, InStream.READ  and OutStream.WRITE are meant to be in binary format, which means that Text strings will be ‘zero terminated’ when written, and a ‘zero terminated’ is…