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).

In the mentioned articles we are using the following ADOconnection methods:


Closes a connection


Sets the details used for making a connection. It includes information about provider, server, database, userid and password.


Executes a query statement or a procedure. It takes the parameters commandtext, recordsaffected and option.

  • Commandtext is a sql query statement or a call to a stored procedure.
  • Recordsaffected returns the no. of records affected by the query.
  • Option is used to set how the provider should evaluate the commandtext parameters.

Valid option values are:

-1 adCmdUnspecified Command type argument not specified
1 adCmdText CommandText is a sql query script
2 adCmdTable CommandText is a table name whose columns are all returned by an internally generated SQL query
4 adCmdStoredProc CommandText is a stored procedure name
8 adCmdUnknown Type of command in the CommandText property is unknown.
256 adCmdFile CommandText is the file name of a persistently stored Recordset
512 adCmdTableDirect CommandText is a table name whose columns are all returned

ADOConnection returns a recordset.Ex. ADORecordSet := ADOConnection.Execute(SQLString,RecordsAffected,Option)


Opens a connection. If connectionsstring is not set, it can be used in the open command as a paramenter.

Be the first to comment

Leave a Reply

Your email address will not be published.


This site uses Akismet to reduce spam. Learn how your comment data is processed.