Data.SqlExpr.TSQLDataSet Properties

• Up to Parent: TSQLDataSet

InheritedProtected

Active	published	Specifies whether or not a dataset is open.
ActiveRecord	protected	Indicates the index of the active record in the internal cache of records.
AfterClose	published	Occurs after an application closes a dataset.
AfterOpen	published	Occurs after an application completes opening a dataset and before any data access occurs.
AfterRefresh	published	Occurs after an application refreshes the data in the dataset.
AfterScroll	published	Occurs after an application scrolls from one record to another.
AggFields	public	Contains any aggregate fields.
AutoCalcFields	public	Determines when the OnCalcFields event is triggered and when lookup field values are calculated.
BeforeClose	published	Occurs immediately before the dataset closes.
BeforeOpen	published	Occurs before an application executes a request to open a dataset.
BeforeRefresh	published	Occurs immediately before an application refreshes the data in the dataset.
BeforeScroll	published	Occurs before an application scrolls from one record to another.
BlobBuffer	protected	Reserves a buffer for storing BLOB values.
BlobFieldCount	protected	Indicates the number of columns in the dataset that represent Binary large object (BLOB) fields.
BlockReadSize	public	Determines how many record buffers are read in each block.
Bof	public	Indicates whether the first record in the dataset is active.
Bookmark	public	Specifies the current bookmark in the dataset.
BookmarkSize	protected	Indicates the number of bytes used to represent a bookmark.
BufferCount	protected	Indicates the number of records in the internal cache.
Buffers	protected	Provides indexed access to the record buffers in the internal cache.
CalcBuffer	protected	Points to the record buffer used during an OnCalcFields event.
CalcFieldsSize	protected	Indicates the number of bytes in a record buffer dedicated to storing calculated fields and lookup fields.
CanModify	public	Indicates whether the dataset permits write access to data.
CanRefresh	public
CommandText	published	Specifies the command the dataset executes.
CommandType	published	Indicates the meaning of the CommandText property.
ComObject	public	Specifies the interface reference implemented by the component.
ComponentCount	public	Indicates the number of components owned by the component.
ComponentIndex	public	Indicates the position of the component in its owner's Components property array.
Components	public	Lists all components owned by the component.
ComponentState	public	Describes the current state of the component, indicating when a component needs to avoid certain actions.
ComponentStyle	public	Governs the behavior of the component.
Constraints	protected	Specifies record-level constraints that must be met when editing the data.
CurrentBlobSize	protected	Indicates the size of the most recently read BLOB field.
CurrentRecord	protected	Indicates the index of the current record in the internal cache of record buffers.
DataLink	protected	Identifies the datalink that manages communication between the SQL dataset and another, master dataset.
DataSetField	public	Indicates the persistent TDataSetField object that owns a nested dataset.
DataSource	published	Links the SQL dataset to another (master) dataset.
DbxCommandType	published	Command type in String format.
Designer	public	Returns a pointer to the DataSet designer for the dataset.
DesignerData	public	Stores custom data.
DesignInfo	public	Contains information used by the Form designer.
Disposed	protected	Disposed is a read-only property that shows the current state of this object.
Eof	public	Indicates whether a dataset is positioned at the last record.
FieldCount	public	Indicates the number of field components associated with the dataset.
FieldDefList	public	Points to the list of field definitions for the dataset.
FieldDefs	public	Points to the list of field definitions for the dataset.
FieldList	public	Lists the field components of a dataset.
FieldNoOfs	protected	Specifies the offset needed to convert indexes in the Fields property to field numbers.
FieldOptions	protected	Specifies the options of the dataset fields.
Fields	public	Lists all non-aggregate field components of the dataset.
FieldValues	public	Provides access to the values for all fields in the active record for the dataset.
Filter	public	Specifies the text of the current filter for a dataset.
Filtered	public	Specifies whether or not filtering is active for a dataset.
FilterOptions	public	Specifies whether or not filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records.
Found	public	Indicates whether or not moving to a different record is successful.
GetMetadata	published	Specifies whether the SQL dataset fetches metadata information along with the data.
IndexDefs	public	Contains the definitions of all indexes defined on the server for the dataset.
InternalCalcFields	protected	Indicates whether the dataset includes internally calculated fields.
InternalConnection	protected	Indicates the component that connects the dataset to its database server, taking into account whether the connection was cloned.
IsUniDirectional	public	Indicates whether the dataset is unidirectional.
MaxBlobSize	published	Indicates the maximum number of bytes fetched for any BLOB field in the dataset.
Modified	public	Indicates whether the active record is modified.
Name	published	Specifies the name of the component as referenced in code.
NativeCommand	protected	Represents the SQL command that is sent to the server.
NestedDataSetClass	protected	Indicates the class type to use when creating nested datasets.
NestedDataSets	protected	Lists all nested datasets.
NumericMapping	published	Maps fldBCD to either ftFMTBCD or ftBCD field types.
ObjectView	published	Specifies whether fields are stored hierarchically or flattened out in the Fields property.
Observers	public	Indicates the TObservers object added to the TComponent.
OnCalcFields	published	Occurs when an application recalculates calculated fields.
Owner	public	Indicates the component that is responsible for streaming and freeing this component.
ParamCheck	published	Specifies whether the parameter list for an SQL dataset is regenerated when the SQL command changes.
ParamCount	protected	Indicates the number of parameters listed by the Params property.
Params	published	Represents the parameters for a query or stored procedure.
Prepared	public	Specifies whether the command is prepared before execution.
ProcParams	protected	ProcParams lists the parameter descriptors obtained from the server for any stored procedure parameters.
RecNo	public	Indicates the active record number in the dataset.
RecordCount	public	Indicates the total number of records associated with the dataset.
RecordSize	public	Indicates the size of a record in the dataset.
RowsAffected	protected	Indicates the number of rows operated on by the latest query execution.
SchemaInfo	protected	Identifies the metadata with which to populate the dataset.
SchemaName	published	Specifies the name of the database schema.
SortFieldNames	published	Indicates the sort order when CommandType is ctTable.
SparseArrays	public	Determines whether a unique TField object is created for each element of an array field.
SQLConnection	published	Specifies the SQL connection component that connects the dataset to a database server.
State	public	Indicates the current operating mode of the dataset.
Tag	published	Stores a NativeInt integral value as a part of a component.
VCLComObject	public	Represents information used internally by components that support COM.