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.