Record

The ADO Record object can contain a row from a Recordset object, or a directory or file from a file system.

Prior to the introduction of the Record object, only structured databases could be accessed by ADO. In a structured database, each table has the exact same number of columns (fields) in each row (record), and each column is composed of the same data type. In other words, the structure of every row in the database is the same. The Record object expands the usefulness of ADO by allowing access to sets of data where the number of columns and/or the data type can vary from row to row. For example, it can handle sets of data that are in a tree-like structure composed of a root with nodes and leaves.

The fields associated with the Record object can be viewed by using the Fields Collection.

Properties

ActiveConnection	Sets or returns a variant value defining the Connection object to which the Record object belongs (or a string value if there is no connection).
Mode	Sets or returns the provider access permission (the ConnectModeEnum value) for a Record object.
ParentURL	Returns a string value that is the absolute URL of the record in the Record object.
RecordType	Returns a RecordTypeEnum that is the type of the Record object.
Source	Returns a variant value that is the source parameter of the Open method of the Record object.
State	Returns a long value describing if the Record object is open or closed.

Methods

Cancel	Cancels the execution of a pending CopyRecord, DeleteRecord, MoveRecord, or Open call.
Close	Closes a Record object.
CopyRecord	Copies a file, or a directory and its contents, to a specified location.
DeleteRecord	Deletes a file, or a directory and all of its contents.After such a delete, you need to close the Record object.
GetChildren	Returns a Recordset object where each row represents a file or directory.
MoveRecord	Moves a file, or a directory and its contents, to a specified location.
Open	Use to open an existing Record object, or to create a new file or directory.

Collections

Fields

The Fields Collection is a collection of all of the Field objects associated with a specific Record object.