ADO Record Object

Record object (ADO version 2.5)

The ADO Record object is used to contain a row in a record set, or a file or directory in the file system.

Versions of ADO prior to 2.5 were only able to access structured databases. In a structured database, each table has an exact number of columns in every row, and each column is composed of the same data type.

The Record object allows access to datasets where the number of columns and/or data types between rows differ.

Syntax

objectname.property
objectname.method

Property

Property Description
ActiveConnection Set or return the Connection object currently owned by the Record object.
Mode Set or return the effective permissions for modifying data in the Record object.
ParentURL Return the absolute URL of the parent Record.
RecordType Return the type of the Record object.
Source Set or return the src parameter of the Open method of the Record object.
State Return the state of the Record object.

Method

Method Description
Cancel Cancel the execution of a CopyRecord, DeleteRecord, MoveRecord, or Open call.
Close Close a Record object.
CopyRecord Copy a file or directory to another location.
DeleteRecord Delete a file or directory.
GetChildren Returns a Recordset object where each row represents a file or subdirectory in the directory.
MoveRecord Move a file or directory to another location.
Open Open an existing Record object or create a new file or directory.

Collection

Collection Description
Properties A collection of specific provider properties.
Fields Contains all Field objects in the Record object.

Properties of the Fields Collection

Property Description
Count

Returns the number of items in the fields collection. The starting value is 0.

Example:

	countfields = rec.Fields.Count
Item(named_item/number)

Returns a specified item from the fields collection.

Example:

	itemfields = rec.Fields.Item(1)
	Or
	itemfields = rec.Fields.Item("Name")