ADO Record object

Home >> ADO >> ADO Record object

ADO Record object

Record Object

The Record object is used to hold a row in a Recordset, or a directory or file in a file system.

Syntax

objectname.property objectname.method

Properties

Property Description

ActiveConnection Sets or returns a definition for a connection if the connection is closed, or the current Connection object if the connection is open

Mode Sets or returns the provider access permission

ParentURL Returns the absolute url of the parent Record

RecordType Returns the type of Record object

Source Returns the src argument of the Record object's Open method

State Returns a value describing if the Record object is open or closed

Methods

Method Description

Cancel Cancels an execution

Close Closes a Record object

CopyRecord Copies a file or directory

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

Open Opens an existing Record object, creates a new file, or creates a new directory

Collections

Collection Description

Fields Indicates the number of Field objects in the Record object

The Fields Collection's Properties

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")

Open Directory Site ADO Tutorials