Accelerating into the Future with Wisdom about Technology! Ingrid Byllemos
This is a detailed description for the used ADOCommand command in the articles Stored Procedures and Navision and ADO in Navision.
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 the rest of this entry »
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 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 the rest of this entry »
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:
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.
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:
Lets take a close look on how to do it in C# ADO.NET
If you have to optimize a lot of tables and indexes. You could create a SQL script, which then could be scheduled.