synolog_vpn

Using a Synology NAS as VPN Server

Did you know that it is possible to use a Synology NAS as VPN Server? You can install the VPN Server from the Package Center.

ms_convergence2013

Microsoft Dynamics Convergence 2013

This year Microsoft Dynamics Convergence 2013 is taking place in New Orleans. Unfortunately I will not be able to attend the Convergence – but I’m still able to following it

Code-Dynamic-Logo-v2

Locking and Unlocking Objects

With Microsoft Dynamics NAV 2009 R2 the possibility for locking and unlocking objects was introduced and does also exist in NAV 2013. Locking and unlocking objects is very useful in environments where multiple developers are working together in the same […]

 

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 field as text!

In the following sorting example you can see the sorting Native vs. SQL
Read more »

Using SQL Views in Navision

code-dynamics

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 afterwards be used from Navision.

First you have to create the SQL View. This is can be done in 2 ways on the SQL Server.

One way is to use the Microsoft SQL Server Management. Here you right click on View select New where you afterwards can select tables, joins, fields etc.

Read more »

Importing Image from a non Navision table to a Navision blob field

code-dynamics

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 fields.

There exists 2 ways to get this fields value.

1) One way is to stream the image to a file and then afterwards import it into the blob.

Read more »

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 is a technique which allows you to extract data from a web page.
Read more »

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.
Read more »

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 using setAttribute directly on the XML Dom Element. To prevent a crash, use a function to set the Attribute.
Read more »