2.2.18. ADO Record object

Record object (ADO version 2.5) ¶

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

Versions prior to ADO 2.5 can only access structured databases. In a structured database, each table has exactly the same number of columns in each row, and each column is made up of the same data type.

Record object allows access to datasets with the number of columns and /or different data types between rows.

Grammar ¶

objectname.property objectname.method 

Attribute ¶

Attribute	Description
ActiveConnection	Sets or returns the Record object to which the Connection object currently belongs.
Mode	Sets or returns valid permissions to modify data in a 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.

Method ¶

Method	Description
`Cancel`	Cancel once `CopyRecord` 、 `DeleteRecord` 、 `MoveRecord` or the `Open` execution of the call.
`Close`	Close one. `Record` object.
`CopyRecord`	Copy a file or directory to another location.
`DeleteRecord`	Delete a file or directory.
`GetChildren`	Returns a `Recordset` object, where each line 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.

Set ¶

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

Properties of the Fields collection ¶

Attribute	Description
`Count`	Return the `fields` number of items in the collection. The starting valueis 0. Example: countfields = rec.Fields.Count
`Item(named_item/number)`	Return `fields` a specified item in the collection. Example: itemfields = rec.Fields.Item(1) 或者 itemfields = rec.Fields.Item("Name")

Attribute

Description

Count

Return the fields number of items in the collection. The starting valueis 0.

Example:

countfields = rec.Fields.Count 

Item(named_item/number)

Return fields a specified item in the collection.

Example:

itemfields = rec.Fields.Item(1) 或者 itemfields = rec.Fields.Item(&quot;Name&quot;) 