Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a Dynaset and Snapshot and
how would you create one?
- 2 Answers
- 22123 Views
- I also Faced
- E-Mail Answers
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 would you navigate between one document to another document in Internet Explorer ?
I have several megabytes of memory. Why do I get an "out of memory" error?
Data Control missing from toolbox when I use VB under NT3.5. Why?
Where can I get updated VB and other Microsoft files?
How do I make the mouse cursor invisible/visible?
What are the uses of List View Control?
What are the important components of OLEDB?
by writing MACRO CODE,i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.
How do I call a DLL?
which method used to move a recordset pointer in nth position in DAG?
Hi, I am USINg QTP tool for automation. Where VB Script have to use. I want to read a row from the table present in .Doc File and to paste in excel. Could you please assist me or give me the code to get it. I am new in this technology.
How do you avoid the "Invalid use of null" error when reading null values from a database?
Can you create a Updatecascade, Deletecascade relation in Ms- Access?
what are the types of LockEdits in DAO?
Explain about trees structures work.
