ADO Record Object
Record Object (ADO version 2.5)
The ADO Record object is used to hold a row in a recordset, or a file or directory in the file system.
Versions prior to ADO 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 between rows may differ.
Syntax
Properties
| Property |
Description |
| ActiveConnection |
Sets or returns the Connection object to which the Record object currently belongs. |
| Mode |
Sets or returns the valid permissions 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 for 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 where 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 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 specific item in the fields collection. Example: itemfields = rec.Fields.Item(1) or itemfields = rec.Fields.Item("Name") |