Name 

Description 

 

Active 

Specifies whether or not a dataset is open. 

 

GetMetadata 

Specifies whether the SQL dataset fetches metadata information along with the data. 

 

IndexFieldNames 

Lists the fields to use for sorting records and for linking in master/detail relationships. 

 

IndexName 

Identifies an index to use for sorting records and for linking the table as the detail of a master/detail relationship. 

 

MasterFields 

Identifies the fields from the master dataset to use for linking this table as the detail of a master/detail relationship. 

 

MasterSource 

Identifies the master dataset to use when linking this table as the detail of a master/detail relationship. 

 

MaxBlobSize 

Indicates the maximum number of bytes fetched for any BLOB field in the dataset. 

 

Name 

Specifies the name of the component as referenced in code. 

 

NumericMapping 

Maps fldBCD to either ftFMTBCD or ftBCD field types. 

 

ObjectView 

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

 

SchemaName 

Specifies the name of the database schema. 

 

SQLConnection 

Specifies the SQL connection component that connects the dataset to a database server. 

 

TableName 

Specifies the table on the database server represented by this component. 

 

Tag 

Stores an integer value as part of a component.