Class Recordset (ADODB VBA)

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

The classes Command, Connection and Record. give access to class Recordset

Methods

AddNew - Creates a new record for an updatable Recordset object.

Cancel - Cancels execution of a pending, asynchronous method call.

CancelBatch - Cancels a pending batch update.

CancelUpdate - Cancels any changes made to the current or new row of a Recordset object, or the Fields collection of a Record object, before calling the Update method.

Clone - Creates a duplicate Recordset object from an existing Recordset object. Optionally, specifies that the clone be read-only.

Close - Closes an open object and any dependent objects.

CompareBookmarks - Compares two bookmarks and returns an indication of their relative values.

Delete - Deletes an object from the Fields collection.

Find - Searches a Recordset for the row that satisfies the specified criteria. Optionally, the direction of the search, starting row, and offset from the starting row may be specified. If the criteria is met, the current row position is set on the found record; otherwise, the position is set to the end (or start) of the Recordset.

GetRows - Retrieves multiple records of a Recordset object into an array.

GetString - Returns the Recordset as a string.

Move - Moves the position of the current record in a Recordset object.

MoveFirst - Moves to the first, last, next, or previous record in a specified Recordset object and makes that record the current record.

MoveLast - Moves to the first, last, next, or previous record in a specified Recordset object and makes that record the current record.

MoveNext - Moves to the first, last, next, or previous record in a specified Recordset object and makes that record the current record.

MovePrevious - Moves to the first, last, next, or previous record in a specified Recordset object and makes that record the current record.

NextRecordset - Clears the current Recordset object and returns the next Recordset by advancing through a series of commands.

Open - Opens a cursor.

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

Resync - Refreshes the data in the current Recordset object, or Fields collection of a Record object, from the underlying database.

Save - Saves the Recordset in a file or Stream object.

Seek - Searches the index of a Recordset to quickly locate the row that matches the specified values, and changes the current row position to that row.

Supports - Determines whether a specified Recordset object supports a particular type of functionality.

Update - Saves any changes you make to the current row of a Recordset object, or the Fields collection of a Record object.

UpdateBatch - Writes all pending batch updates to disk.

Properties

Fields (Default member) - Contains all the Field objects of a Recordset or Record object.

AbsolutePage indicates on which page the current record resides.

AbsolutePosition indicates the ordinal position of a Recordset object's current record.

ActiveCommand indicates the Command command that created the associated Recordset command.

BOF bOF Indicates that the current record position is before the first record in a Recordset object.

Bookmark indicates a bookmark that uniquely identifies the current record in a Recordset object or sets the current record in a Recordset object to the record identified by a valid bookmark.

CacheSize indicates the number of records from a Recordset object that are cached locally in memory.

CursorLocation indicates the location of the cursor service.

CursorType indicates the type of cursor used in a Recordset object.

DataMember indicates the name of the data member that will be retrieved from the object referenced by the DataSource property.

DataSource indicates an object that contains data to be represented as a Recordset object.

EditMode indicates the editing status of the current record.

EOF bOF Indicates that the current record position is before the first record in a Recordset object.

Filter indicates a filter for data in a Recordset.

Index indicates the name of the index currently in effect for a Recordset object.

LockType indicates the type of locks placed on records during editing.

MarshalOptions indicates which records are to be marshaled back to the server.

MaxRecords indicates the maximum number of records to return to a Recordset from a query.

PageCount indicates how many pages of data the Recordset object contains.

PageSize indicates how many records constitute one page in the Recordset.

Properties contains all the Property objects for a specific instance of an object.

RecordCount indicates the number of records in a Recordset object.

Sort indicates one or more field names on which the Recordset is sorted, and whether each field is sorted in ascending or descending order.

State indicates for all applicable objects whether the state of the object is open or closed.

Status indicates the status of a Field object.

StayInSync indicates, in a hierarchical Recordset object, whether the reference to the underlying child records (that is, the chapter) changes when the parent row position changes.

Fields - Contains all the Field objects of a Recordset or Record object.

Properties - Contains all the Property objects for a specific instance of an object.