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. 

Comments

Popular posts from this blog

Migrating database from ASP.NET Identity to ASP.NET Core Identity

Customize User's Profile in ASP.NET Identity System