What is the difference between a Dynaset and Snapshot and
how would you create one?
Answer Posted / suresh
A dynaset-type Recordset object is a dynamic set of records
that can contain fields from one or more tables or queries
in a database and may be updatable. In an ODBCDirect
database, a dynaset-type Recordset object corresponds to an
ODBC keyset cursor.
Remarks
A dynaset-type Recordset object is a type of Recordset
object you can use to manipulate data in an underlying
database table or tables.
It differs from a snapshot-type Recordset object because
the dynaset stores only the primary key for each record,
instead of actual data. As a result, a dynaset is updated
with changes made to the source data, while the snapshot is
not. Like the table-type Recordset object, a dynaset
retrieves the full record only when it's needed for editing
or display purposes.
A snapshot-type Recordset object is a static set of records
that you can use to examine data in an underlying table or
tables. In an ODBCDirect database, a snapshot-type
Recordset object corresponds to a static cursor.
Remarks
To create a snapshot-type Recordset object, use the
OpenRecordset method on an open database, on another
dynaset- or snapshot-type Recordset object, or on a
QueryDef object.
Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
Is it posible to Create Tables Through Querydef?
When/Why should I use Option Explicit?
What is the use of progress Bar Control?
Explain about the basic features of Visual basic?
Is it possible to Access BackEnd procedures? Explain.
What is FireHouse Cursors?
How many objects resides in ADO ?
what are the Types of Resultsets?
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
Is it possible to Manipulate data through flexgrid? Explain.
What is ado in vb?
How do I make my applications screen-resolution independent?
what are the different Types of Recordsets.
what are the types of LockEdits in DAO?
To validate a range of values for a property whenever the property values changes,which type of property procedure you use?