Name 

Description 

 

BlobBuffer 

Reserves a buffer for storing BLOB values. 

 

CommandType 

Indicates the meaning of the CommandText property. 

 

CurrentBlobSize 

Indicates the size of the most recently read BLOB field. 

 

DataLink 

Identifies the datalink that manages communication between the SQL dataset and another, master dataset. 

 

DataSource 

Links the SQL dataset to another (master) dataset. 

 

DbxCommandType 

This is DbxCommandType, a member of class TCustomSQLDataSet. 

 

InternalConnection 

Indicates the component that connects the dataset to its database server, taking into account whether the connection was cloned. 

 

MaxBlobSize 

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

 

NativeCommand 

Represents the SQL command that is sent to the server. 

 

ParamCheck 

Specifies whether the parameter list for an SQL dataset is regenerated when the SQL command changes. 

 

ParamCount 

Indicates the number of parameters listed by the Params property. 

 

Params 

Represents the parameters for a query or stored procedure. 

 

ProcParams 

ProcParams lists the parameter descriptors obtained from the server for any stored procedure parameters. 

 

RowsAffected 

Indicates the number of rows operated on by the latest query execution. 

 

SchemaInfo 

Identifies the metadata with which to populate the dataset. 

 

SortFieldNames 

Indicates the sort order when CommandType is ctTable. 

 

Name 

Description 

 

CommandText 

Specifies the command the dataset executes. 

 

DesignerData 

Stores custom data. 

 

IndexDefs 

Contains the definitions of all indexes defined on the server for the dataset. 

 

Prepared 

Specifies whether the command is prepared before execution. 

 

RecordCount 

Indicates the total number of records associated with the dataset. 

 

SQLConnection 

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

 

TransactionLevel 

Indicates the transaction to which this dataset belongs. 

 

Name 

Description 

 

Active 

Specifies whether or not a dataset is open. 

 

GetMetadata 

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

 

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.