• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

16.1. Recordset Objects

The main tool for manipulating data is the Recordset object. There are three types of Recordset objects:

  • A table-type Recordset object is a representation of the records in a single table in the database. It is like a window into the table. Thus, operations on this type of recordset directly affect the table. We emphasize that a table-type recordset can be opened for a single table only. It cannot be opened for a join of more than one table, or for a query. A table-type recordset can be indexed using a table index. This provides for quick manuvering within the table, using the Seek method, which we will discuss later in the chapter.

  • A dynaset-type Recordset object is a dynamic (changeable) set of records that can contain fields from one or more tables or queries. Dynaset-type recordsets are generally updatable in both directions. Thus, changes in the recordset are reflected in the underlying tables or queries and changes in the underlying tables or queries are reflected in the dynaset-type recordset. With a dynaset-type recordset, no data are brought into memory. Rather a unique key is brought into memory to reference each row of data. Searching through a dynaset-type recordset is done with the Find method, which is generally slower than the Seek method (which uses one of the table's indexes).

  • A snapshot-type Recordset object is a static (nonchangeable) set of records that can contain fields from one or more tables or queries. These recordsets cannot be updated. For searching, a snapshot-type recordset can be faster than a dynaset-type recordset.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint