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.