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.
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?
Most keys can be represented by the character of the key itself. E.g, the key sequence HALLO can be represented simply by “HALLO”.
Some special keys, such as the control keys, function keys etc are encoded in a string enclosed by {braces}
See the table below:
Read the rest of this entry »