ADO Record Object

Record Object (ADO version 2.5)

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

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.

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. 


Syntax

objectname.property
objectname.method


Properties

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


Methods

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


 

Collections

Collection

Description

Properties

A collection of provider-specific properties

Fields

Contains all the 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")

 

ADO Record

Login
ADS CODE