.NET
Writing a FTP automation
Over some time I have been using a plain dos ftp from Navision. There is some advantages and some disadvantage combined with it. A advantage is, that this use does not require any third part […]
Development
C/AL & AL
Playfair Cipher in Navision
As earlier mentioned I have being reading some books about Cryptology – and now its Playfairs turn to be tested in Navision 🙂 Playfair Cipher (aka. Playfair square) is a symmetric encryption technique and was […]
.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 […]
.NET
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.
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 […]
Development
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.
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
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 […]