ADO Recordset Object

Recordset Object

The ADO Recordset object is used to hold a set of records from a database table. A Recordset object consist of records and columns (fields).

In ADO, this object is the most important and the one used most often to manipulate data from a database.

ProgID

When you first open a Recordset, the current record pointer will point to the first record and the BOF and EOF properties are False. If there are no records, the BOF and EOF property are True.

Recordset objects can support two types of updating: 

• Immediate updating - all changes are written immediately to the database once you call the Update method.
• Batch updating - the provider will cache multiple changes and then send them to the database with the UpdateBatch method.

In ADO there are 4 different cursor types defined:

• Dynamic cursor - Allows you to see additions, changes, and deletions by other users.
• Keyset cursor - Like a dynamic cursor, except that you cannot see additions by other users, and it prevents access to records that other users have deleted. Data changes by other users will still be visible.
• Static cursor - Provides a static copy of a recordset for you to use to find data or generate reports. Additions, changes, or deletions by other users will not be visible. This is the only type of cursor allowed when you open a client-side Recordset object.
• Forward-only cursor - Allows you to only scroll forward through the Recordset. Additions, changes, or deletions by other users will not be visible. 

The cursor type can be set by the CursorType property or by the CursorType parameter in the Open method.

Note: Not all providers support all methods or properties of the Recordset object.

 

Practice Excercise Practice now

Collections

Collection	Description
Fields	Indicates the number of Field objects in the Recordset object
Properties	Contains all the Property objects in the Recordset object

Practice Excercise Practice now

The Fields Collection's Properties

Property	Description
Count	Returns the number of items in the fields collection. Starts at zero. Example: countfields=rs.Fields.Count
Item(named_item/number)	Returns a specified item in the fields collection. Example: itemfields=rs.Fields.Item(1) or itemfields=rs.Fields.Item("Name")

Practice Excercise Practice now

The Properties Collection's Properties

Property	Description
Count	Returns the number of items in the properties collection. Starts at zero. Example: countprop=rs.Properties.Count
Item(named_item/number)	Returns a specified item in the properties collection. Example: itemprop = rs.Properties.Item(1) or itemprop=rs.Properties.Item("Name")

Practice Excercise Practice now