C/AL & AL
NAV 2018 – Crashing the debugger!
Did you know that you can crash the debugger? Just make some “dump” code that uses functions meant for AL and voila you have a weird error and a crash. I wanted to play around […]
Development
C/AL & AL
NAV 2018 – What’s new in C/AL
Ok, I know we should be talking about AL when looking into NAV 2018 – but why not start with something for the old dinosaurs first. So what has changed in C/AL. First we got […]
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. […]
.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 […]
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 […]
Automations
ADO in Navision
With ADO you can execute SQL Scripts and Stored Procedures from Navision. To use ADO in Navision, you have to use the automation “Microsoft ActiveX Data Objects 2.8 Library” Lets take a closer on how […]