Jump to content

Recordset

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Ed Poor (talk | contribs) at 18:35, 30 November 2006 (sheesh, it's not just Microsoft. How about SAP, perl, etc+). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

A recordset is a data structure that consists of a group of database records, and can either come from a base table or as the result of a query to the table.

The concept is common to a number of platforms, notably Microsoft's Data Access Objects (DAO) and ActiveX Data Objects (ADO). The RecordSet object contains a Fields collection and a Properties collection. At any time, the Recordset object refers to only a single record within the set as the current record.