Development – Page 5

ADORecordSet

28 February 2008 iby 0

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 […]

ADOCommand

28 February 2008 iby 0

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

28 February 2008 iby 0

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 […]

Sendkeys in Visual Basic Scripts

27 February 2008 iby 0

Sendkeys can also be used from a Visual Basic Scripts, which means you can ex. build a vbs file, that can be used for starting up applications, or executing steps that you often have to […]

Stored Procedures and Navision

21 February 2008 iby 0

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

20 February 2008 iby 5

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 […]

ADO.NET

19 February 2008 iby 0

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: […]

Problems when loading XML

16 October 2007 iby 0

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 […]

XML in Navision

12 October 2007 iby 2

In Navision there are 2 ways to handle XMLs. In all versions it is possible to use the automation Microsoft XML and from Navision 4 it is possible to use XML ports. XML ports are […]

XML Schemas & DTDs

11 October 2007 iby 0

XML are validated with a DTD or with an XML Schema. Document Type Definition (DTD) defines the legal elements of an XML Document. <!DOCTYPE note SYSTEM “external.dtd”> <root> XML Schema is an XML-based alternativ to […]