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.
Year: 2008
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 […]
Kiss DP-558 Dead or alive?
Recently one of my colleagues experiences some problem with his Kiss player. It was and still is not possible to turn it on and in the display it only writes “KISS DVD”. I had a […]
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 […]
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 […]