AdoRecordset Class

<< Click to Display Table of Contents >>

Navigation:  Ado Classes >

AdoRecordset Class

Previous pageReturn to chapter overviewNext page

Purpose

 

A Recordset object represents the entire set of records from a base table or the results of an executed command.

 

Prototype

 

CLASS AdoRecordset INHERIT AdoAdo

 

Constructor

 

 

 

Init()

Create Object of type AdoRecordSet

 

 

 

Access

 

AbsolutePage

The page on which the current record resides.

AbsolutePosition

The ordinal position of a Recordset object's current record.

ActiveCommand

The Command object that created the associated Recordset object

ActiveConnection

The Connection object the RecordSet object currently belongs.

BOF

Is the current record position before the first record in a Recordset object ?

Bookmark

A bookmark that Uniquely identifies a particular record in a Recordset

CacheSize

The number of records from a Recordset object that are cached locally in memory.

Collect

The collect property allows you to directly read or write field values

CloseOnAxit

Does the recordset automatically get closed when VO discards the object ?

CursorLocation

The location of the cursor service.

CursorType

The type of cursor used in a Recordset object.

DataMember

The name of the data member to retrieve from the object referenced by the DataSource property

DataSource

An object containing data to be represented as a Recordset object.

EditMode

Indicates the editing status of the current record.

EOF

Is the current record position After the first record in a Recordset object ?

Fields

Fields Collection

Filter

A filter for data in a Recordset

Index

The name of the index currently in effect for a Recordset object

LockType

The type of locks placed on records during editing.

MarshalOptions

Which records are to be marshaled back to the server

MaxRecords

The maximum number of records to return to a Recordset from a query.

PageCount

How many pages of data the Recordset object contains

PageSize

How many records constitute one page in the Recordset

RecordCount

The current number of records in a Recordset object

Sort

One or more field names on which the Recordset is sorted

Source

The source for the data in a Recordset object

State

Is the object open or closed.

Status

The status of the current record with respect to batch updates or other bulk operations

StayInSync

Do child records stay in sync with parent records

 

 

Assign

 

AbsolutePage

The page on which the current record resides.

AbsolutePosition

The ordinal position of a Recordset object's current record.

ActiveConnection

The Connection string or object the RecordSet object currently belongs.

Bookmark

A bookmark that Uniquely identifies a particular record in a Recordset

CacheSize

The number of records from a Recordset object that are cached locally in memory.

Collect

The collect property allows you to directly read or write field values

CloseOnAxit

Does the recordset automatically get closed when VO discards the object

CursorLocation

The location of the cursor service.

CursorType

The type of cursor used in a Recordset object.

DataMember

The name of the data member to retrieve from the object referenced by the DataSource property

DataSource

An object containing data to be represented as a Recordset object.

Filter

A filter for data in a Recordset

Index

The name of the index currently in effect for a Recordset object

LockType

The type of locks placed on records during editing.

MarshalOptions

Which records are to be marshaled back to the server

MaxRecords

The maximum number of records to return to a Recordset from a query.

PageSize

How many records constitute one page in the Recordset

Sort

One or more field names on which the Recordset is sorted

Source

 

The source for the data in a Recordset object

StayInSync

 

Do child records stay in sync with parent records

 

 

Method

 

AddNew()

Creates a new record for an updatable Recordset object.

Cancel()

Cancels the currently running asynchronous fetch

CancelBatch()

Cancels a pending batch update

CancelUpdate()

Cancels any changes made to the current record or to a new record

Clone()

Creates a duplicate Recordset object from an existing Recordset object.

Close()

Closes an open Recordset and any dependent objects

CompareBookmarks()

Compares two bookmarks and returns an indication of their relative values

Delete()

Deletes the current record or a group of records

DisableEvents()

Disable Event handling

EnableEvents()

Enable Event handling

FieldGet()

Read Field values

FieldPut()

Write Field values

Find()

Searches a Recordset for the row that satisfies the specified criteria.

GetRows()

Retrieves multiple records of a Recordset object into an array

GetString()

Returns the Recordset as a string.

Move()

Moves the position of the current record in a Recordset object

MoveFirst()

Moves to the first record in a Recordset

MoveLast()

Moves to the last record in a Recordset

MoveNext()

Moves to the next record in a Recordset

MovePrevious()

Moves to the previous record in a Recordset

NextRecordset()

Clears the current Recordset object and returns the next Recordset

NoIvarGet()

General error interception

NoIvarPut()

General error interception

Open()

Opens a cursor.

Requery()

Updates the data in a Recordset object by re-executing the query on which the object is based.

Resync()

Refreshes the data in the current Recordset object from the underlying database.

Save()

Saves (persists) the Recordset in a file or Stream object.

Seek()

Searches the index of a Recordset to quickly locate the row that matches the pecified values

Supports()

Determines whether a specified Recordset object supports a particular type of functionality.

Update()

Saves any changes you make to the current record of a Recordset object.

UpdateBatch()

Writes all pending batch updates to disk.

 

See Also

 

AdoAdo, AdoCommand, AdoConnection, ADO Classes