Expand Minimize

ADO Properties

AbsolutePage

Indicates on which page the current record resides.

AbsolutePosition

Indicates the ordinal position of the current record of a Recordset object.

ActiveCommand

Indicates the Command object that created the associated Recordset object.

ActiveConnection

Indicates to which Connection object the specified Command, Recordset, or Record object currently belongs.

ActualSize

Indicates the actual length of a field's value.

Attributes

Indicates one or more characteristics of an object.

BOF and EOF

BOF indicates that the current record position is before the first record in a Recordset object.

EOF indicates that the current record position is after the last record in a Recordset object.

Bookmark

Indicates a bookmark that uniquely identifies the current record in a Recordset object or sets the current record in a Recordset object to the record identified by a valid bookmark.

CacheSize

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

Chapter

Gets or sets an OLE DB Chapter object from/on an ADORecordsetConstruction object.

CharSet

Indicates the character set into which the contents of a text Stream should be translated.

CommandStream

Indicates the stream used as the input to a Command object.

CommandText

Indicates the text of a command to be issued against a provider.

CommandTimeout

Indicates how long to wait while executing a command before terminating the attempt and generating an error.

CommandType

Indicates the type of a Command object.

ConnectionString Property

Indicates the information used to establish a connection to a data source.

ConnectionTimeout

Indicates how long to wait while establishing a connection before terminating the attempt and generating an error.

Count

Indicates the number of objects in a collection.

CursorLocation

Indicates the location of the cursor service.

CursorType

Indicates the type of cursor used in a Recordset object.

DataMember

Indicates the name of the data member that will be retrieved from the object referenced by the DataSource property.

DataSource

Indicates an object that contains data to be represented as a Recordset object.

DefaultDatabase

Indicates the default database for a Connection object.

DefinedSize

Indicates the data capacity of a Field object.

Description

Describes an Error object.

Dialect

Indicates the syntax and general rules that the provider will use to parse the CommandText or CommandStream properties.

Direction

Indicates whether the Parameter represents an input parameter, an output parameter, or both, or if the parameter is the return value from a stored procedure.

EditMode

Indicates the editing status of the current record.

EOS

Indicates whether the current position is at the end of the stream.

Filter

Indicates a filter for data in a Recordset.

HelpContext and HelpFile

Indicates the Help file and topic associated with an Error object.

HelpContextID returns a context ID, as a Long value, for a topic in a Help file.

HelpFile returns a String value that evaluates to a fully resolved path of a Help file.

Index

Indicates the name of the index currently in effect for a Recordset object.

IsolationLevel

Indicates the level of isolation for a Connection object.

Item

Indicates a specific member of a collection, by name or ordinal number.

LineSeparator

Indicates the binary character to be used as the line separator in text Stream objects.

LockType

Indicates the type of locks placed on records during editing.

MarshalOptions

Indicates which records are to be marshaled back to the server.

MaxRecords

Indicates the maximum number of records to return to a Recordset from a query.

Mode

Indicates the available permissions for modifying data in a Connection, Record, or Stream object.

Name

Indicates the name of an object.

NativeError

Indicates the provider-specific error code for a particular Error object.

Number

Indicates the number that uniquely identifies an Error object.

NumericScale

Indicates the scale of numeric values in a Parameter or Field object.

OriginalValue

Indicates the value of a Field that existed in the record before any changes were made.

PageCount

Indicates how many pages of data the Recordset object contains.

PageSize

Indicates how many records represent one page in the Recordset.

ParentRow

Sets the container of an OLE DB Row object on an ADORecordConstruction object, so that the parent of the row is turned into an ADO Record object.

ParentURL

Indicates an absolute URL string that points to the parent Record of the current Record object.

Position

Indicates the current position within a Stream object.

Precision

Indicates the degree of precision for numeric values in a Parameter object or for numeric Field objects.

Prepared

Indicates whether to save a compiled version of a command before execution.

Provider

Indicates the name of the provider for a Connection object.

RecordCount

Indicates the number of records in a Recordset object.

RecordType

Indicates the type of Record object.

Row

Gets or sets an OLE DB Row object from/on an ADORecordConstruction object.

RowPosition

Gets or sets an OLE DB RowPosition object from/on an ADORecordsetConstruction object.

Rowset

Gets or sets an OLE DB Rowset object from/on an ADORecordsetConstruction object.

Source (ADO Error)

Indicates the name of the object or application that originally generated an error.

Source (ADO Record)

Indicates the entity represented by the Record object.

Source (ADO Recordset)

Indicates the source for the data in a Recordset object

SQLState

Indicates the SQL state for a specific Error object.

State

Indicates for all applicable objects whether the state of the object is open or closed. Indicates for all applicable objects executing an asynchronous method, whether the current state of the object is connecting, executing, or retrieving

Status (ADO Field)

Indicates the status of a Field object.

Status (ADO Recordset)

Indicates the status of the current record regarding batch updates or other bulk operations.

StayInSync

Indicates, in a hierarchical Recordset object, whether the reference to the underlying child records (that is, the chapter) changes when the parent row position changes.

Stream Property

Gets or sets an OLE DB Stream object from/on an ADOStreamConstruction object.

Type

Indicates the operational type or data type of a Parameter, Field, or Property object.

Type (ADO Stream)

Indicates the type of data that is contained in the Stream (binary or text).

UnderlyingValue

Indicates the current value in the database for a Field object.

Value

Indicates the value assigned to a Field, Parameter, or Property object.

Version

Indicates the ADO version number.

Show:
© 2014 Microsoft