Category: Basics

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 SQL Server configuration.

So what to do when receiving this error? That’s simple – add the trace flag ;-)
Read more »

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 »

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 SQL request.

Fixed keys are ok – but in large tables, it is not always a good idea to a lot of keys. Therefore often you will see that they have a minimized set of keys. A lot will properly be deactivated.
Read more »

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 strings. E.g. store the info in several fields, variables or a text file – that was imported to a blob field.

From Navision 4 it was suddenly possible to handle strings with a length up till 2147483647 characters – this is equivalent to 2 gb. In Navision 4 the data type BigText was introduced.
Read more »

No. Series – are they usable?

In Navision number series are used to handle invoices, credit memo’s, customers etc. – actually they are pretty widely used around in Navision.

So how does number series work?
Read more »

C/SIDE

Navision Customizations is done in C/SIDE.

C/SIDE (Client / Server Integrated Development Environment) is the core of Navision and is the foundation for almost all functionality in Navision. It is made up of 5-7 building blocks called objects (tables, forms, reports, dataports, codeunits, xmlports (introduced in ver. 4), menusuites (introduced in ver. 4)). These objects types are shared throughout Navision, which resolves in a uniform and consistent interface to the application.