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
How do I change the color of a form in visual basic?
Parts of ODBC?
How can I change the printer Windows uses in code without using the print common dialog? How can I change orientation?
What is meant by Establish Connection in RDO? 74.1s it possible to Access BackEnd procedures? Explain.
How would you add elements and pictures to listitems in listview control?
What is controls in vb?
Explain about creating VB applications in excel?
Explain Default cursor Type and LockEdits type in RDO?
Explain the differences between ActiveX Dll and ActiveX Exe?
Explain Default cursor Type and LockEdit type in DAO?
Types of LockEdits in RDO.
How many types of API functions are available in VB?
How can you Implement windows functionality in VB?
How would you use ActiveX Dll and ActiveX Exe in your application?
What is Pseudocode?