Development
How to transfer user logins between to SQL Servers
Hi ! If you are installing a new SQL Server and would like to transfer the logins from an old SQL Server, without doing a SQL restore, then you can do it with a script. […]
SQL
.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 […]
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 […]
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
ADORecordSet
Hi ! This is a detailed description for the used ADORecordSet command mentioned in the articles Stored Procedures and Navision and ADO in Navision. ADORecordSet The ADO RecordSet is defined by the automation ‘Microsoft ActiveX […]
Automations
ADOCommand
This is a detailed description for the used ADOCommand command in the articles Stored Procedures and Navision and ADO in Navision. ADOCommand The ADO Command is defined by the automation ‘Microsoft ActiveX Data Objects 2.8 […]
Automations
ADOConnection
Hi ! I have been asked to describe the different ADO commands parameters more explicit. So here are a detailed description for the used ADOconnection command in the articles Stored Procedures and Navision and ADO […]
Automations
Stored Procedures and Navision
If you are executing a specific SQL query very often, it would be usefully to have it as Stored Procedure on the SQL Server. Stored Procedures is a collection of SQL statements. There are 2 […]