This is a detailed description for the used ADORecordSet command mentioned in the articles Stored Procedures and Navision and ADO in Navision.
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:
Sets the definition for the current connection.
Closes a RecordSet.
Returns true if the recordset is at the end of the buffered response (after the last record), otherwise it is false.
Returns a specific Items value. Fields are a collection of Items.
Go to the first Record in the RecordSet.
Go the next record in the RecordSet.
Opens a connection to a database element, which gives access to records in a table, query results or saved recordsets.
Leave a Reply