Wiki Home

ADO RecordSet Properties


Namespace: WIN_COM_API
ADO Recordset properties:

Property

Purpose

AbsolutePage

Specifies which page the current record inhabits

AbsolutePosition

Location of the current record in the Recordset

ActiveCommand

The Command object from which the Recordset gets its data

Active Connection

The Connection object or string that the Recordset object uses

BOF, EOF

Flags specifying that the current position is the beginning (BOF) or end (EOF) of the Recordset

Bookmark

Marker to uniquely identify a record in the Recordset

CacheSize

Determines how many records will be saved locally during modification or viewing

Cursor Location

Where processing of the data will take place, on the server or on the client

Cursor Type

Type of cursor to use with the Recordset

DataMember, DataSource

Used by Visual Studio Data Environment to bind Recordsets to controls

EditMode

Edit state of the current record

Filter

Filter applied to the Recordset to limit records

Lock Type

Database locking schema setting share rights for data

MarshalOptions

Specifies which records will be returned to the data store after modification, all or modified only

MaxRecords

Limits number of records that a Recordset can return to the client

PageCount

Total number of pages in a Recordset

Page Size

Size of a record in paging

RecordCount

Number of records in a Recordset

Sort

Sorting to use to organize data in Recordset

Source

Original SQL string or command string upon which the Recordset is based

State

Indicates the current state or action of the Recordset object

Status

Status of the current record with respect to modifications and updates

StayInSync

Used with hierarchical Recordsets to set whether child Recordsets should move as movement occurs in the parent Recordset


Category ADO
( Topic last updated: 1999.10.24 08:40:04 PM )