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 Data Objects Recordset 2.8 Library’.Recordset or by ‘Microsoft ActiveX Data Objects 2.8 Library’.Recordset

It is used to hold a set of records from a from a database table or a defined query. The Recordset object contains rows and columns (fields).

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

ADORecordset.ActiveConnection

Sets the definition for the current connection.

ADORecordSet.Close

Closes a RecordSet.

ADORecordSet.EOF

Returns true if the recordset is at the end of the buffered response (after the last record), otherwise it is false.

ADORecordSet.Fields.Item(‘Name’).Value

Returns a specific Items value. Fields are a collection of Items.

ADORecordSet.MoveFirst

Go to the first Record in the RecordSet.

ADORecordSet.MoveNext

Go the next record in the RecordSet.

ADORecordset.Open

Opens a connection to a database element, which gives access to records in a table, query results or saved recordsets.