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 […]
Development
C# and Dns.GetHostEntry
I am currently building a new FTP automation for Navision. During this I discovered that Dns.GetHostEntry is not always stable.
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 […]
Splitting files using Visual Basic Scripts
Do you occasionally need to split a file based on its content? If yes – then this can be done quickly by using a Visual Basic Script and “Scripting.FileSystemObject”. Lets take a closer look.
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 […]
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 […]
Enabling keys on the fly in Navision
In the earlier version of Navision it was not possible to enable keys on the fly. All you could do was either having fixed keys, using key groups or doing a “hack” with performing a […]
Strings larger then 250 characters
In the early version of Navision it was only possible to handle string with a length up till 250 characters. This was often not enough and there was only a few ways to handle those […]