Recordset in Visual Basic 6

Introduction

Recordset is logical set of records where Microsoft defines a record as 'A set of related data about a person, place, event or some other item'. Table data is stored in records (rows) in the database. Each record is composed of a set of related fields (columns) - each field defining one attribute of information for the record. Taken together, a record defines one specific unit of retrievable information in a database.

There are five types of Recordset:

(i) Table-type Recordset

Basically it is a complete table from a database. We can use to add, change or delete records. This is the simplest in concept since it matches a complete table in the database, but is not necessarily the best choice in many applications.

(ii) Dynaset-type Recordset

The result of a query that can have updatable records, we can use to add, change or delete records. It can contain fields from one or more tables in a database and it provides worse performance than a table-type Recordset.

(iii) Snapshot-type Recordset

A read-only set of records that we can use to find data or generate reports; it can contain fields from one or more tables in a database but can't be updated. It uses a minimum of resources and provides fast performance.

(iv) Forward-only-type Recordset

 Identical to a snapshot except that no cursor is provided. We can only scroll forward through records. This improves performance in situations where you only need to make a single pass through a Recordset.

(v) Dynamic-type Recordset

A query result set from one or more base tables in which you can add, change or delete records from row-returning query. Further, records other uses add, delete or edit in the base tables also appear in our Recordset.