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 […]
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 […]
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 […]
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 […]
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?
Keys in SendKeys
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 […]
Issues with Sendkeys
When using Sendkeys there is one big issue, you can not see when/if the application is in the correct state. This means you have to build in some kind of wait states and then after […]
Sendkeys in Navision
With SendKeys you simulate user keystrokes – which mean it is possible to start applications, enter information, choose menus, buttons etc. SendKeys is a part of Windows Script Host. Currently I am using this functionality […]
Problems when loading XML
A load will not work if the document contains a DTD / Schema definition where the validation file cannot be found! Ex. a XML containing the following will not be able to be loaded because […]