O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Table 13-1. Recordset ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required