O'Reilly logo

ASP in a Nutshell, 2nd Edition by A. Keyton Weissinger

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

Recordset

A Recordset object represents the records returned from a query (or table) and a cursor into those records. When instantiating a Recordset object, you can automatically create a connection to the underlying data provider on opening the recordset. However, if you use an already open Connection object for your recordset, you can significantly reduce your memory consumption overhead, since each Connection object can maintain multiple recordsets. However, if you open a recordset without using an already open Connection object, that connection can support only that single recordset. You can read more about this feature in the section on the Open method of the Recordset object. Table 12.20, Table 12.21, and Table 12.22 list the Recordset object's properties, collections, and methods, respectively.

Table 12.20. Recordset Object Properties

Property

Description

AbsolutePage

Allows you to determine the exact page of records in which the current record resides. Each recordset is broken up by the data provider and ADO into pages of PageSize number of records, with the last page possibly containing fewer records. This is a read-only value of type Long.

AbsolutePosition[17]

The ordinal number of the current record in the recordset. This is a read/write value of type Long.

ActiveCommand

Read-only property containing the name of the Command object that was used to create the current Recordset object.

ActiveConnection[17]

The currently open Connection object to which the ...

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