YouTip

# ADO Record Object * * * ## Record Object (ADO version 2.5) The ADO Record object is used to hold a row from a recordset, or a file/directory from a 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 each 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 may vary between rows. ### 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 available permissions for modifying data in the Record object. | | ParentURL | Returns the absolute URL of the parent Record. | | RecordType | Returns the type of Record object. | | Source | Sets or returns the src parameter of the Record object's Open method. | | State | Returns the state of the Record object. | ## Methods | Method | Description | | --- | --- | | Cancel | Cancels 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 a directory. | | MoveRecord | Moves a file or directory to another location. | | Open | Opens an existing Record object or creates a new file/directory. | ## Collections | Collection | Description | | --- | --- | | Properties | A collection of provider-specific properties. | | Fields | Contains all Field objects of the Record object. | ## Properties of Fields Collection | Property | Description | | --- | --- | | Count | Returns the number of items in the fields collection. Starts from 0. Example: countfields = rec.Fields.Count | | Item(named_item/number) | Returns a specified item from the fields collection. Example: itemfields = rec.Fields.Item(1) or itemfields = rec.Fields.Item("Name") |