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

Recordset Objects

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

Table-type Recordset object

A representation of the records in a single table of the database. It is like a window into the table. Thus, operations on this type of recordset directly affect the table. I 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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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