ADO RecordObject

Record Object (ADO version 2.5)

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

ADO versions prior to 2.5 could only access structured databases. In a structured database, each table has exactly the same number of columns in every row, and each column consists of the same data type.

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

Syntax

objectname.property
objectname.method

Properties

Property Description
ActiveConnection Sets or returns the Connection object to which the Record object currently belongs.
Mode Sets or returns the effective permission for modifying data in the Record object.
ParentURL Returns the absolute URL of the parent Record.
RecordType Returns the type of the Record object.
Source Sets or returns the src parameter of the Open method of the Record object.
State Returns the state of the Record object.

Methods

Method Description
Cancel Cancels the execution of a CopyRecord, DeleteRecord, MoveRecord, or Open call.
Close Closes a Record object.
CopyRecord Copies a file or directory to another location.
DeleteRecord Deletes a file or directory.
GetChildren Returns a Recordset object in which each row represents a file or subdirectory in the directory.
MoveRecord Moves a file or directory to another location.
Open Opens an existing Record object or creates a new file or directory.

Collections

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

Fields Collection Properties

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 in the fields collection.

Example:

itemfields = rec.Fields.Item(1)
或者
itemfields = rec.Fields.Item("Name")
Other extensions