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 […]
Software
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 […]
Operating Systems
What happend to Vista’s defrag?
Like or not – but so far as I can see, Microsoft has downgraded the defragmentation functionality in Vista. First, the user interface has changed. There is no progress bar, no elapsed time and no […]
Operating Systems
Are you also annoyed by Windows Vista’s User Account Control?
Are you also annoyed by Windows Vista’s User Account Control? If Yes – there is a way to turn it of 🙂 Before you turn off User Account Control, then be aware off why you […]
C/AL & AL
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 […]
Automations
How to listen for a Port in Navision
Have you ever needed to make Web requests to Navision? Often you then would be using either NAS or a 3’rd part product to handle these requests. Why not build your own handler 😉 All […]
C/AL & AL
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 […]