ADO Recordset Object

The Recordset Object |
A Recordset object represents the entire set of records from a base table or the results of an executed command. At any time, the Recordset object only refers to a single record within the set as the current record.

AddNew |
| Method
Creates a new record for an updateable Recordset object.

Cancel |
| Method
Cancels execution of a pending asynchronous Open operation.

CancelBatch |
| Method
Cancels a pending batch update.

CancelUpdate |
| Method
Cancels any changes made to the current record, or to a new record prior to calling the Update method.

Clone |
Returns: Recordset | Method
Creates a duplicate Recordset object from and existing Recordset object.

Close |
| Method
Closes the Recordset object and any dependent objects.

CompareBookmarks |
Returns: Compare Enum | Method
Compares two bookmarks and returns an indication of the relative values.

Delete |
| Method
Deletes the current record or group of records.

Find |
| Method
Searches the Recordset for a record that matches the specified criteria.

GetRows |
Returns: Variant | Method
Retrieves multiple records of a Recordset object into an array.

GetString |
Returns: String | Method
Returns a Recordset as a string.

Move |
| Method
Moves the recordset cursor to point at a Recordset.

MoveFirst |
| Method
Moves the recordset cursor to point at the first record in the Recordset.

MoveLast |
| Method
Moves the recordset cursor to point at the last record in the Recordset.

MoveNext |
| Method
Moves the recordset cursor to point at the next record in the Recordset.

MovePrevious |
| Method
Moves the recordset cursor to point at the previous record in the Recordset.

NextRecordset |
Returns: Recordset | Method
Clears the current Recordset object and returns the next Recordset by advancing through a series of commands.

Open |
| Method
Opens a Recordset.

Requery |
| Method
Updates the data in a Recordset object by re-executing the query on which the object is based.

Resync |
| Method
Refreshes the data in the current Recordset object from the underlying database.

Save |
| Method
Saves the Recordset to a file.

Seek |
| Method
Searches the recordset index to locate a value

Supports |
Returns: Boolean | Method
Determines whether a specified Recordset object supports particular functionality.

Update |
| Method
Saves any changes made to the current Recordset object.

UpdateBatch |
| Method
Writes all pending batch updates to disk.

AbsolutePage |
Returns: PositionEnum | Property
Specifies in which page the current record resides.

AbsolutePosition |
Returns: PositionEnum | Property
Specifies the ordinal position of a Recordset object's current record.

ActiveCommand |
Returns: Object | Property
Indicates the Command object that created the associated Recordset object. Read only.

ActiveConnection |
Returns: Variant | Property
Indicates to which Connection object the specified Recordset object currently belongs.

BOF |
Returns: Boolean | Property
Indicates whether the current record is before the first record in a Recordset object. Read only.

Bookmark |
Returns: Variant | Property
Returns a bookmark that uniquely identifies the current record in a Recordset object, or sets the current record to the record identified by a valid bookmark.

CacheSize |
Returns: Long | Property
Indicates the number of records from a Recordset object that are cached locally in memory.

CursorLocation |
Returns: CursorLocation Enum | Property
Sets or returns the location of the cursor engine.

CursorType |
Returns: CursorType Enum | Property
Indicates the type of cursor used in a Recordset object.

DataMember |
Returns: String | Property
Specifies the name of the data member to retrieve from the object referenced by the DataSource property. Write only.

DataSource |
Returns: Object | Property
Specifies an object containing data to be represented as a Recordset object. Write only.

EditMode |
Returns: EditModeEnum | Property
Indicates the editing status of the current record. Read only.

EOF |
Returns: Boolean | Property
Indicates whether the current record is after the last record in a Recordset object. Read only.

Fields |
Returns: Fields | Property
Contains all of the Field objects for the current Recordset object.

Filter |
Returns: Variant | Property
Indicates a filter for data in the Recordset.

Index |
Returns: String | Property
Identifies the name of the index currently being used.

LockType |
Returns: LockTypeEnum | Property
Indicates the type of locks placed on records during editing.

MarshalOptions |
Returns: MarshalOptions Enum | Property
Indicates which records are to be marshaled back to the server.

MaxRecords |
Returns: Long | Property
Indicates the maximum number of records to return to a Recordset object from a query. Default is zero (no limit).

PageCount |
Returns: Long | Property
Indicates how many pages of data the Recordset object contains. Read only.

PageSize |
Returns: Long | Property
Indicates how many records constitute one page in the Recordset.

Properties |
Returns: Properties | Property
Contains all of the Property objects for the current Recordset object.

RecordCount |
Returns: Long | Property
Indicates the current number of records in the Recordset object. Read only.

Sort |
Returns: String | Property
Specifies one or more field names the Recordset is sorted on, and the direction of the sort.

Source |
Returns: String | Property
Indicates the source for the data in a Recordset object.

State |
Returns: Long | Property
Indicates whether the recordset is open, closed, or whether it is executing an asynchronous operation. Read only.

Status |
Returns: Integer | Property
Indicates the status of the current record with respect to match updates or other bulk operations. Read only.

StayInSync |
Returns: Boolean | Property
Indicates, in a hierarchical Recordset object, whether the parent row should change when the set of underlying child records changes. Read only.

EndOfRecordset |
| Event
Fired when there is an attempt to move to a row past the end of the Recordset.

FetchComplete |
| Event
Fired after all the records in an asynchronous operation have been retrieved into the Recordset.

FetchProgress |
| Event
Fired periodically during a lengthy asynchronous operation, to report how many rows have currently been retrieved.

FieldChangeComplete |
| Event
Fired after the value of one or more Field objects have been changed.

MoveComplete |
| Event
Fired after the current position in the Recordset changes.

RecordChangeComplete |
| Event
Fired after one or more records change.

RecordsetChangeComplete |
| Event
Fired after the Recordset has changed.

WillChangeField |
| Event
Fired before a pending operation changes the value of one or more Field objects.

WillChangeRecord |
| Event
Fired before one or more rows in the Recordset change.

WillChangeRecordset |
| Event
Fired before a pending operation changes the Recordset.

WillMove |
| Event
Fired before a pending operation changes the current position in the Recordset.