Class Record (ADODB VBA)

The class Record represents a row from a Recordset or the data provider, or an object returned by a semi-structured data provider, such as a file or directory.

Methods

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

Close - Closes an open object and any dependent objects.

CopyRecord - Copies a entity represented by a Record to another location.

DeleteRecord - Deletes a the entity represented by a Record.

GetChildren - Returns a Recordset whose rows represent the children of a collection Record.

MoveRecord - Moves the entity represent by a Record to another location.

Open - Opens an existing Record object, or creates a new item represented by the Record (such as a file or directory).

Properties

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

Mode indicates the available permissions for modifying data in a Connection, Record, or Stream object.

ParentURL indicates an absolute URL string that points to the parent Record of the current Record object.

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

RecordType indicates the type of Record object.

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

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.

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.