Search Results

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 »

ADO in Navision

code-dynamics

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 to make a SQL connection and perform a SQL Query in Navision.

Read more »

ADO.NET

For test purpose I did a little test in C#, where I did use ADO.NET to make a connection to my SQL Server.

The common way to access a database is to do the following:

  1. Open a connection to the Database
  2. Perform the Query using a recordset for the returned data
  3. Extract Data needed and close the recordset
  4. Close the connection

Lets take a close look on how to do it in C# ADO.NET

Read more »

What is ADO and can it be used in Navision?

ADO (ActiveX Data Objects) is a Microsoft technology and is a interface to access data in a database.

So what can ADO be used for in Navision?

Read more »