Recordsets

[Puneet Bhatnagar]

Hi
I want to know what are the various types of Recorset Available in Visual Basic.
Like i know the names table,dynaset-type ,snapshot type . What i want to know is what is the differance between them

[albertw]

Hi
I want to know what are the various types of Recorset Available in Visual Basic.
Like i know the names table,dynaset-type ,snapshot type . What i want to know is what is the differance between them

hi

Table-type Recordset — representation in code of a base table that you can use to add, change, or delete records from a single database table (Microsoft Jet workspaces only).


Dynaset-type Recordset — the result of a query that can have updatable records. A dynaset-type Recordset object is a dynamic set of records that you can use to add, change, or delete records from an underlying database table or tables. A dynaset-type Recordset object can contain fields from one or more tables in a database. This type corresponds to an ODBC keyset cursor.


Snapshot-type Recordset — a static copy of a set of records that you can use to find data or generate reports. A snapshot-type Recordset object can contain fields from one or more tables in a database but can't be updated. This type corresponds to an ODBC static cursor.

[ source MSDN ]

[Puneet Bhatnagar]

Thanks buddy