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. 

 

AutoRefresh 

Specifies whether server-generated field values are refetched automatically. 

 

CachedUpdates 

Specifies whether cached updates are enabled for a dataset. 

 

Constrained 

Indicates whether updates and inserts that don't conform to the result set generated by a SELECT statement are permitted for Paradox and dBASE tables 

 

Constraints 

Specifies record-level constraints that must be met when editing the data. 

 

DatabaseName 

Specifies the name of the database associated with this dataset. 

 

DataSource 

Specifies the data source component from which to extract current field values to use with same-name parameters in the query's SQL statement. 

 

Filter 

Specifies the text of the current filter for a dataset. 

 

Filtered 

Specifies whether or not filtering is active for a dataset. 

 

FilterOptions 

Specifies whether or not filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records. 

 

Name 

Specifies the name of the component as referenced in code. 

 

ObjectView 

Specifies whether fields are stored hierarchically or flattened out in the Fields property. 

 

ParamCheck 

Specifies whether the parameter list for a query is regenerated if the SQL property changes at runtime. 

 

Params 

Contains the parameters for a query's SQL statement. 

 

RequestLive 

Requests an updatable query result set from the database. 

 

SessionName 

Identifies the name of the session with which this dataset is associated. 

 

SQL 

Contains the text of the SQL statement to execute for the query. 

 

Tag 

Stores an integer value as part of a component. 

 

UniDirectional 

Determines whether or not Borland Database Engine (BDE) bidirectional cursors are enabled for a query's result set. 

 

UpdateMode 

Determines how the Borland Database Engine (BDE) finds records when updating to an SQL database. 

 

UpdateObject 

Specifies the update object component used to update a read-only result set when cached updates are enabled.