By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,781 Members | 1,134 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,781 IT Pros & Developers. It's quick & easy.

Recordsets

P: 6
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
Nov 17 '06 #1
Share this Question
Share on Google+
2 Replies


100+
P: 267
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 ]
Nov 17 '06 #2

P: 6
Thanks buddy
Nov 17 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.