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

Jump to: Top of Page or HOME or Printer friendly page

Search W3Schools:

What Others Say About Us

Does the world know about us? Check out these places:

Dogpile Alta Vista MSN Google Excite Lycos Yahoo Ask Jeeves

We Help You For Free. You Can Help Us!

W3Schools is for training only. We do not warrant its correctness or its fitness for use. The risk of using it remains entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

How we converted to XHTML

ASP Ecommerce & Shopping Cart

Your own Web Site?

Read W3Schools
Hosting Tutorial

$15 Domain Name
Registration
Save $20 / year!

Advertise
at W3Schools

Only 0.5 CPM

SELECTED LINKS

University Online
Master Degree
Bachelor Degree

Web Software

The Future of
Web Development

Jobs and Careers

Web Security
Web Statistics
Web Standards

PARTNERS

W3Schools
TopXML
VisualBuilder
XMLPitstop
DevelopersDex
DevGuru
Programmers Heaven
The Code Project
Tek Tips Forum
ZVON.ORG
TopXML Search