Data.SqlExpr.TSQLQuery Properties

From RAD Studio API Documentation
Jump to: navigation, search

InheritedProtected
ActivepublishedSpecifies whether or not a dataset is open.
ActiveRecordprotectedIndicates the index of the active record in the internal cache of records.
AfterClosepublishedOccurs after an application closes a dataset.
AfterOpenpublishedOccurs after an application completes opening a dataset and before any data access occurs.
AfterRefreshpublishedOccurs after an application refreshes the data in the dataset.
AfterScrollpublishedOccurs after an application scrolls from one record to another.
AggFieldspublicContains any aggregate fields.
AutoCalcFieldspublicDetermines when the OnCalcFields event is triggered and when lookup field values are calculated.
BeforeClosepublishedOccurs immediately before the dataset closes.
BeforeOpenpublishedOccurs before an application executes a request to open a dataset.
BeforeRefreshpublishedOccurs immediately before an application refreshes the data in the dataset.
BeforeScrollpublishedOccurs before an application scrolls from one record to another.
BlobBufferprotectedReserves a buffer for storing BLOB values.
BlobFieldCountprotectedIndicates the number of columns in the dataset that represent Binary large object (BLOB) fields.
BlockReadSizepublicDetermines how many record buffers are read in each block.
BofpublicIndicates whether the first record in the dataset is active.
BookmarkpublicSpecifies the current bookmark in the dataset.
BookmarkSizeprotectedIndicates the number of bytes used to represent a bookmark.
BufferCountprotectedIndicates the number of records in the internal cache.
BuffersprotectedProvides indexed access to the record buffers in the internal cache.
CalcBufferprotectedPoints to the record buffer used during an OnCalcFields event.
CalcFieldsSizeprotectedIndicates the number of bytes in a record buffer dedicated to storing calculated fields and lookup fields.
CanModifypublicIndicates whether the dataset permits write access to data.
CanRefreshpublic
CommandTextpublicSpecifies the command the dataset executes.
CommandTypeprotectedIndicates the meaning of the CommandText property.
ComObjectpublicSpecifies the interface reference implemented by the component.
ComponentCountpublicIndicates the number of components owned by the component.
ComponentIndexpublicIndicates the position of the component in its owner's Components property array.
ComponentspublicLists all components owned by the component.
ComponentStatepublicDescribes the current state of the component, indicating when a component needs to avoid certain actions.
ComponentStylepublicGoverns the behavior of the component.
ConstraintsprotectedSpecifies record-level constraints that must be met when editing the data.
CurrentBlobSizeprotectedIndicates the size of the most recently read BLOB field.
CurrentRecordprotectedIndicates the index of the current record in the internal cache of record buffers.
DataLinkprotectedIdentifies the datalink that manages communication between the SQL dataset and another, master dataset.
DataSetFieldpublicIndicates the persistent TDataSetField object that owns a nested dataset.
DataSourcepublishedLinks the SQL dataset to another (master) dataset.
DbxCommandTypeprotectedCommand type in String format.
DesignerpublicReturns a pointer to the DataSet designer for the dataset.
DesignerDatapublicStores custom data.
DesignInfopublicContains information used by the Form designer.
DisposedprotectedDisposed is a read-only property that shows the current state of this object.
EofpublicIndicates whether a dataset is positioned at the last record.
FieldCountpublicIndicates the number of field components associated with the dataset.
FieldDefListpublicPoints to the list of field definitions for the dataset.
FieldDefspublicPoints to the list of field definitions for the dataset.
FieldListpublicLists the field components of a dataset.
FieldNoOfsprotectedSpecifies the offset needed to convert indexes in the Fields property to field numbers.
FieldOptionsprotectedSpecifies the options of the dataset fields.
FieldspublicLists all non-aggregate field components of the dataset.
FieldValuespublicProvides access to the values for all fields in the active record for the dataset.
FilterpublicSpecifies the text of the current filter for a dataset.
FilteredpublicSpecifies whether or not filtering is active for a dataset.
FilterOptionspublicSpecifies whether or not filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records.
FoundpublicIndicates whether or not moving to a different record is successful.
GetMetadatapublishedSpecifies whether the SQL dataset fetches metadata information along with the data.
IndexDefspublicContains the definitions of all indexes defined on the server for the dataset.
InternalCalcFieldsprotectedIndicates whether the dataset includes internally calculated fields.
InternalConnectionprotectedIndicates the component that connects the dataset to its database server, taking into account whether the connection was cloned.
IOBufferSizeprotected
IsUniDirectionalpublicIndicates whether the dataset is unidirectional.
MaxBlobSizepublishedIndicates the maximum number of bytes fetched for any BLOB field in the dataset.
ModifiedpublicIndicates whether the active record is modified.
NamepublishedSpecifies the name of the component as referenced in code.
NativeCommandprotectedRepresents the SQL command that is sent to the server.
NestedDataSetClassprotectedIndicates the class type to use when creating nested datasets.
NestedDataSetsprotectedLists all nested datasets.
NumericMappingpublishedMaps fldBCD to either ftFMTBCD or ftBCD field types.
ObjectViewpublishedSpecifies whether fields are stored hierarchically or flattened out in the Fields property.
ObserverspublicIndicates the TObservers object added to the TComponent.
OnCalcFieldspublishedOccurs when an application recalculates calculated fields.
OwnerpublicIndicates the component that is responsible for streaming and freeing this component.
ParamCheckpublishedSpecifies whether the parameter list for an SQL dataset is regenerated when the SQL command changes.
ParamCountprotectedIndicates the number of parameters listed by the Params property.
ParamspublishedRepresents the parameters for a query or stored procedure.
PreparedpublicSpecifies whether the command is prepared before execution.
ProcParamsprotectedProcParams lists the parameter descriptors obtained from the server for any stored procedure parameters.
RecNopublicIndicates the active record number in the dataset.
RecordCountpublicIndicates the total number of records associated with the dataset.
RecordSizepublicIndicates the size of a record in the dataset.
RowsAffectedpublicIndicates the number of rows operated on by the latest query execution.
SchemaInfoprotectedIdentifies the metadata with which to populate the dataset.
SchemaNamepublishedSpecifies the name of the database schema.
SortFieldNamesprotectedIndicates the sort order when CommandType is ctTable.
SparseArrayspublicDetermines whether a unique TField object is created for each element of an array field.
SQLpublishedSpecifies the SQL statement to execute on the database server.
SQLConnectionpublishedSpecifies the SQL connection component that connects the dataset to a database server.
StatepublicIndicates the current operating mode of the dataset.
TagpublishedStores a NativeInt integral value as a part of a component.
TextpublicIndicates the SQL statement as a single string.
VCLComObjectpublicRepresents information used internally by components that support COM.