ADO 记录对象

记录对象（ADO 版本 2.5）

ADO Record 对象用于保存 Recordset 中的行、目录或文件系统中的文件。

在 2.5 之前的版本中，ADO 只能访问结构化数据库。在结构化数据库中，每个表的每行具有完全相同的列数，并且每列由相同的数据类型组成。

Record 对象允许访问行与行之间的列数和/或数据类型可能不同的数据集。

objectname.property
objectname.method

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

Method	Description
Cancel	Cancels an 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 where each row represents the files in the directory
MoveRecord	Moves a file or a directory to another location
Open	Opens an existing Record object or creates a new file or directory

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

Property	Description
Count	Returns the number of items in the fields collection. Starts at zero. Example: countfields=rec.Fields.Count
Item(named_item/number)	Returns a specified item in the fields collection. Example: itemfields=rec.Fields.Item(1) or itemfields = rec.Fields.Item("Name")

Property

Description

Count

Returns the number of items in the fields collection. Starts at zero.

Example:

countfields=rec.Fields.Count

Item(named_item/number)

Returns a specified item in the fields collection.

Example:

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