The ADO Record object is used to hold a row in a Recordset, a directory, or a file from a file system.
ADO Record对象的作用是：持续保存一个记录集、目录或文件系统中文件的行数据。
Only structured databases could be accessed by ADO in versions prior 2.5. In a structured database, each table has the exact same number of columns in each row, and each column is composed of the same data type.
结构化数据库只能被ADO2.5以上版本访问。在结构化数据库中，每个表格中的每行都包含相同数量的列，而且每列都是由相同的数据类型组成。
The Record object allows access to data-sets where the number of columns and/or the data type can be different from row to row.
Record[记录]对象允许访问指定列数的数据，且/或行与行之间的数据类型也可以彼此不同。
objectname.property |
| Property属性 | Description描述 |
|---|---|
| ActiveConnection | Sets or returns which Connection object a Record object belongs to 设置或返回一个Record[记录]对象所属的Connection[连接]对象 |
| Mode | Sets or returns the permission for modifying data in a Record object 设置或返回对一个Record[记录]对象中的数据修改的权限 |
| ParentURL | Returns the absolute URL of the parent Record 返回父级记录的绝对URL |
| RecordType | Returns the type of a Record object 返回一个Record[记录]对象的类型 |
| Source | Sets or returns the src parameter of the Open method of a Record object 设置或返回一个Record[记录]对象的Open方式中的src参数 |
| State | Returns the status of a Record object 返回Record[记录]对象的状态 |
| Method方法 | Description描述 |
|---|---|
| Cancel | Cancels an execution of a CopyRecord, DeleteRecord, MoveRecord, or Open call 取消对CopyRecord、DeleteRecord、MoveRecord或Open的请求 |
| Close | Closes a Record object 关闭一个Record[记录]对象 |
| 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 返回一个Recordset[记录集]对象。在该对象中，每一行都代表了目录中的文件 |
| MoveRecord | Moves a file or a directory to another location 将一个文件或一个目录移动到其它地址 |
| Open | Opens an existing Record object or creates a new file or directory 打开一个现有的Record[记录]对象或创建一个新的文件或目录 |
| Collection集合 | Description描述 |
|---|---|
| Properties | A collection of provider-specific properties 指定一个技术提供者[provider]详细的属性集合 |
| Fields | Contains all the Field objects in the Record object 指定包含Record[记录]对象中所有的Field[字段]对象 |
| Property属性 | Description描述 |
|---|---|
| Count | Returns the number of items in the fields collection. Starts at zero. 返回字段集合中项的数量。以0为起始 Example: countfields = rec.Fields.Count |
| Item(named_item/number) | Returns a specified item in the fields collection. 返回字段集合中一个指定的项 Example: itemfields = rec.Fields.Item(1) |
