Page 517 - Microsoft Office Excel 2003 Programming Inside Out

Introducing ADO

The Recordset Object

When a database request returns rows to your program, they are made available through the
Recordset object.

Key Properties and Methods of the Recordset Object

Table 23-8 lists some of the key properties and methods associated with the Recordset object.

Table 23-8. Key Properties and Methods of the Recordset Object
Property/Method Description
ActiveConnection Property: points to an open Connection object that will be used to
execute the command or contains a connection string that will be
used to connect to the database.
AddNew Method: adds a new row to the end of the Recordset.
BOF Property: returns True when the current record pointer is before the
first record in the recordset.
CancelUpdate Method: restores the current row in the Recordset to its original
values.
Close Method: closes an open Recordset object and releases all
its resources.
Delete Method: deletes the current record.
EditMode Property: describes the edit status of the current record. Can be
adEditNone (current record is unchanged), adEditInProgress
(current record has been changed, but not saved), adEditAdd (the
AddNew method created a new, empty record, which hasn’t been
saved yet), or adEditDelete (the current record is deleted).
EOF Property: returns True when the current record pointer is past the
last row in the recordset.
Fields Property: returns a Fields collection containing the set of fields
associated with the current record.
Filter Property: can be a string containing an expression similar to an Chapter 23
SQL Where clause.
Move(NumRecords) Method: moves the current record pointer forward (positive value)
or backward (negative value) the specified number of rows.
MoveFirst Method: moves the current record pointer to the first row in
the Recordset.
MoveLast Method: moves the current record pointer to the last row in
the Recordset.
continued

491
Part 6: Excel and the Outside World: Collaborating Made Easy