Name 

Description 

 

Command 

Provides access to the internal command object that executes commands for the dataset. 

 

CommandText 

Specifies a command to be executed. 

 

CommandTimeout 

Specifies amount of time to attempt execution of a command. 

 

CommandType 

Specifies the type of command to execute. 

 

DataSource 

Represents the data source of another dataset that supplies values to the dataset. 

 

FieldDefs 

Points to the list of field definitions for the dataset. 

 

IndexDefs 

Contains the definitions of the indexes for the current table. 

 

IndexFieldNames 

Lists the columns to use for a persistent sort of the recordset. 

 

MasterDataLink 

Manages the relationship between the ADO dataset and a master table. 

 

MasterFields 

Specifies field or fields on which a Master-Detail link is based. 

 

ParamCheck 

Specifies whether the parameter list for an ADO dataset component is regenerated if the SQL changes at runtime. 

 

Parameters 

Contains the collection of parameters for an SQL statement. 

 

Prepared 

Specifies whether the command is prepared before execution. 

 

StoreDefs 

Specifies whether field definitions are stored with the ADO dataset. 

 

Name 

Description 

 

DesignerData 

Stores custom data. 

 

EnableBCD 

Specifies whether to treat numeric fields as floating-point or BCD. 

 

FilterGroup 

Filters a recordset based on row update status. 

 

IndexFieldCount 

Indicates the number of fields that comprise the current key. 

 

IndexFields 

Retrieves or sets a field for an index. 

 

IndexName 

Specifies the currently active index. 

 

Properties 

Properties is the implementation of the Properties Collection object. 

 

Recordset 

Provides direct access to the ADO Recordset object. 

 

RecordsetState 

Indicates the current state of the ADO dataset component. 

 

RecordStatus 

Indicates the status of the current row. 

 

Sort 

Specifies the sort order of the recordset. 

 

Name 

Description 

 

Active 

Specifies whether or not a dataset is open. 

 

AutoCalcFields 

Determines when the OnCalcFields event is triggered and when lookup field values are calculated. 

 

CacheSize 

Specifies the size of the cache for the dataset. 

 

Connection 

Specifies the ADO connection component to use. 

 

ConnectionString 

Specifies the connection information for the data store. 

 

CursorLocation 

Specifies whether the cursor for the connection is client-side or server-side. 

 

CursorType 

Specifies type of cursor an ADO dataset uses. 

 

ExecuteOptions 

Specifies the characteristics of a command execution. 

 

Filter 

Specifies the text of the current filter for a recordset. 

 

Filtered 

Specifies whether or not filtering is active for a dataset. 

 

LockType 

Specifies the lock type to use when opening a dataset. 

 

MarshalOptions 

Specifies which records are marshaled back to the server. 

 

MaxRecords 

Specifies how many rows to return in a result set.