Recordset: A
RecordSet, therefore, is a view of some of the data in the database, selected
from the database according to user-specified criteria. The three types of
RecordSets are:
• DynaSets, which
are updatable views of data
• SnapShots, which
are static (read-only) views of data
• Tables, which are
direct views of tables
Dynaset:-
A
Dynaset is temporary set of data taken from one or more table in the form one
of many table in the underlined file. A Dynaset may be a query. That was
defined in a access of table of result of joining multiple tables. Like a
table, a Dynaset is updatable if file is not locked or open for read only. Data
in Dynaset is live that is any changes made to data as project is executing
will appear in Record Set.
Snapshots:-
Snapshot
Record Set, like a dynaset, may be taken from one or more table. The deference
are that snapshot is not updatable and also not live. A snapshot is like
photograph a picture of reality a give point.
Table Record Set:-
Table Record Set
represents a single table as it exits in a Database file. Table Record Set are
usually updatable unless the file is locked of open for read only.
