October 12th, 2008 
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 creating an automation:
Tagged: ADO
Writing an automation for Navision in C#
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 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.
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 Data Objects Recordset 2.8 Library’.Recordset or by ‘Microsoft ActiveX Data Objects 2.8 Library’.Recordset
It is used to hold a set of records from a from a database table or a defined query. The Recordset object contains rows and columns (fields).
Read more »
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 Library’.Command
It is used to execute a query against a database.
Read more »
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 in Navision.
ADOconnection
ADOconnection is defined by the automation ‘Microsoft ActiveX Data Objects 2.8 Library’.Connection
It is used to create and open a connection to a data source (database).
Read more »
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 ways to create a store procedure:
- In the SQL Server Management Studio – you can right click on Stored Procedures and chose to create a new Stored Procedure. It will then create a template for you, which you just have to fill out and execute
- The second way is to build a script by yourself
