Name
Recordset Object — (Versions 2.0, 2.1, 2.5, 2.6)
Synopsis
Dim recordset As ADODB.RecordsetThe Recordset object represents a complete group of rows within a table or a group of records that have been returned from an executed command.
Collections
- Fields
Contains multiple Field objects for the current Recordset object, one for each column in the Recordset object.
- Properties
Contains characteristics specific to the Recordset object for the currently used provider.
Methods
- AddNew
Creates a new record within the current Recordset object and sets it to the specified value.
- Cancel
Cancels an asynchronous operation for the Recordset object.
- CancelBatch
Cancels the currently pending batch update for the current Recordset object.
- CancelUpdate
Cancels any changes to the current batch update made since the last AddNew or Update method calls.
- Clone
Returns a clone of the current recordset.
- Close
Closes a recordset and releases any resources used by it.
- CompareBookmarks
Determines the position of two bookmarks in a recordset in relationship to one another.
- Delete
Deletes specified records within the recordset.
- Find
Moves the record pointer to a row within the current recordset that matches the single-column search criteria specified.
- GetRows
Returns multiple records from an open Recordset object in the form of an array.
- GetString
Returns the entire Recordset object as a String value.
- Move
Moves the position of the record pointer within the desired Recordset object.
- MoveFirst
Moves the record pointer to the first record ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access