Applications
Internal Error 1247 in module 19
I did meet this error for the first time several years ago. Today some of my colleagues saw the message for the first time and did not know what to do about it. Internal Error […]
Navision
.NET
Writing an automation for Navision in C#
Writing a automation for Navision is pretty simple, when you first know how to do it 🙂 First of all, I assume that you already know about C#. So here are the basic steps for […]
Navision
Caesars Cipher in Navision
Lately I have been reading some books about Cryptology and there I stumbled upon Caesars Cipher. Caesars Cipher is a very simple form of Cryptation. Its method is to replace each plaintext letter with one […]
Applications
Trace Flag 4616
When using Navision (Dynamics NAV 5.0 or higher) with SQL 2005 (express or full) – you will receive a trace flag error, when trying to create a new database, unless you already has changed your […]
C/AL & AL
Sorting of a Code field in SQL vs. Native
Did you know that a Code field is sorted different depending of you are using Native or SQL? SQL will sort the Code field as a Varchar – which means it will sort the Code […]
Development
Using SQL Views in Navision
Did you know that it is possible to use views in Navision? If you often are collecting/viewing data from several tables it can be usefull to use a SQL View. Created SQL Views can then […]
Automations
Importing Image from a non Navision table to a Navision blob field
In SQL it is possible to define tables with a column, which is of type image. This field type is not known by Navision or by ADO and can thereby not be extracted like other […]
Automations
HTML Scraping from Navision
Some times you are in the need of showing a web page an afterwards using the results or data from the web page in Navision. This can be done by using HTML Scraping. HTML Scraping […]
Automations
Execution of batch jobs and other programs from Navision
There are at least 2 ways of execution of external batch jobs and programs. One way is to use the SHELL command another way is to use WshShell. Lets start with looking at SHELL.
Automations
XML – SetAttribute can cause Navision to crash
There is an error in the XML DOM automation which can cause Navision to crash. This looks like a kind of memory leak and will therefore often occur in automated/scheduled jobs. The error occurs when […]