ADO Record Object

Record object (ADO version 2.5)

ADO Record object is used to contain a row in a record set, or a file or a directory in the file system

Versions before ADO 2.5 could only access structured databases. In a structured database, each table has the same number of columns in each row, and each column is composed of the same data type.

Record object allows access to datasets with different column numbers and/or data types between rows

Syntax

objectname.property
objectname.method

Property

Property Description
ActiveConnection Set or return Connection object currently owned by Record object
Mode Set or return valid permissions to modify data in Record object
ParentURL Return absolute URL of parent Record
RecordType Return type of Record object
Source Set or return src parameter of Open method of Record object
State Return state of Record object

Method

Method Description
Cancel Fashe kiya a kiya CopyRecord, DeleteRecord, MoveRecord ko a kiya ko kiya a kiya
Close Close
CopyRecord Kopiyar kiya fure ko a kiya kama
DeleteRecord Fashe kiya kama a fure ko a kiya ko kiya a kiya
GetChildren Return a Recordset object where each row represents a file or subdirectory in the directory.
MoveRecord Move a file or directory to another location.
Open Open an existing Record object or create a new file or directory.

Collection

Collection Description
Properties A collection of specific provider properties.
Fields Contains all Field objects in the Record object.

Properties of the Fields Collection

Property Description
Count

Return the number of items in the fields collection. The starting value is 0.

Example:

	countfields = rec.Fields.Count
Item(named_item/number)

Return a specified item in the fields collection.

Example:

	itemfields = rec.Fields.Item(1)
	Or
	itemfields = rec.Fields.Item("Name")