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
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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.
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 […]