What is the difference between a Dynaset and Snapshot and
how would you create one?
Answer Posted / george
All Recordset objects are constructed using records (rows)
and fields (columns). There are five types of Recordset
objects:
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.
Forward-only-type Recordset::
***************************
identical to a snapshot except that no cursor is provided.
You can only scroll forward through records. This improves
performance in situations where you only need to make a
single pass through a result set. This type corresponds to
an ODBC forward-only cursor.
Dynamic-type Recordset ::
**********************
a query result set from one or more base tables in which
you can add,change, or delete records from a row-returning
query. Further, records other users add, delete, or edit in
the base tables also appear in your Recordset. This type
corresponds to an ODBC dynamic cursor (ODBCDirect
workspaces only).
Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
what are the types of LockEdits in DAO?
What is Parser Bug?
What is recordset in visual basic?
Difference between Tabletype and Snapshot?
Through which protocol OLEDB components are interfaced?
1.What are the Feactures visual data manager 2.Short note on visual data manager 3.What is data control,its work,properties,methods 4.Needs for OLEDB in vb 5.LIst steps involved in generating christal report 6.What is a recordset 7.Diffrence between RDO and ADO 8.What is an Activex control 9.Advantages of ADO over data control 10.Diffrence between model and modeless form 11.What is the significance of debug window 12.Diffrence between single document and multiple document 13.Explain data report
What is the default workspace?
What is database vb?
What is instantiating?
What is ODBC Direct and Microsoft Jet Database Engine ?
What are the different procedures associated with the object?
What is datagrid in vb net?
Can a VB application be an OLE server?
What is the use of ActiveX Documents?
Is visual basic c#?