Recordset Methods

Method Name

Description

AddNew

Adds a new row to the current Recordset.

CancelBatch

Cancels the current batch operation.

CancelUpdate

Cancels the current update operation.

Clone

Returns a Recordset that is a duplicate of the existing Recordset.

Close

Closes the current Recordset.

Delete

Deletes the current record or sets of records.

GetRows

Retrieves multiple rows of a Recordset into an array.

Move

Move to a position inside of the current Recordset Object.

MoveNext

Move to the next record inside the current Recordset.

MovePrevious

Move to the previous record inside the current Recordset.

MoveFirst

Move to the first record inside the current Recordset.

MoveLast

Move to the last record inside the current Recordset.

NextRecordset

Returns the next set of Records inside a multiple Recordset result.

Open

Returns a Recordset based on the parameters specified.

Requery

Re-queries the Recordset based on the original opening query.

Resync

Refreshes the data in the Current Recordset.

Supports

Determines if the Recordset will support the specified type of functionality.

Update

Updates the Recordset with any changes we may have made.

UpdateBatch

Commits all pending batch updates.