• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part III: Programming with ADO >  Recordset Objects

Chapter 13. Recordset Objects

All database queries that return data usually transfer it to one or more ADO recordsets. In a database world, a recordset is always based on a table, a query, or a SQL command. A recordset is not considered to be a permanent object. Instead, the data is available only during the recordset object’s lifespan.

The query on which the recordset is based consists of at least one field. A Fields list is used to access the fields. The data determined in a recordset can be processed record by record, row by row, and forward or backward. A record pointer marks the current data row. ADO provides you with a number of methods, described in Tables 13-1 through 13-3, to determine the current record’s position.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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