Bde.DBTables.TQuery 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.
AfterCancelpublishedOccurs after an application completes a request to cancel modifications to the active record.
AfterClosepublishedOccurs after an application closes a dataset.
AfterDeletepublishedOccurs after an application deletes a record.
AfterEditpublishedOccurs after an application starts editing a record.
AfterInsertpublishedOccurs after an application inserts a new record.
AfterOpenpublishedOccurs after an application completes opening a dataset and before any data access occurs.
AfterPostpublishedOccurs after an application writes the active record to the database or change log and returns to browse state.
AfterRefreshpublishedOccurs after an application refreshes the data in the dataset.
AfterScrollpublishedOccurs after an application scrolls from one record to another.
AggFieldspublicContains any aggregate fields.
AutoCalcFieldspublishedDetermines when the OnCalcFields event is triggered and when lookup field values are calculated.
AutoRefreshpublishedSpecifies whether server-generated field values are refetched automatically.
BeforeCancelpublishedOccurs before an application executes a request to cancel changes to the active record.
BeforeClosepublishedOccurs immediately before the dataset closes.
BeforeDeletepublishedOccurs before an application attempts to delete the active record.
BeforeEditpublishedOccurs before an application enters edit mode for the active record.
BeforeInsertpublishedOccurs before an application enters insert mode.
BeforeOpenpublishedOccurs before an application executes a request to open a dataset.
BeforePostpublishedOccurs before an application posts changes for the active record to the database or change log.
BeforeRefreshpublishedOccurs immediately before an application refreshes the data in the dataset.
BeforeScrollpublishedOccurs before an application scrolls from one record to another.
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.
CacheBlobspublicDetermines whether BLOB fields are cached in memory.
CachedUpdatespublishedSpecifies whether cached updates are enabled for a dataset.
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
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.
ConstrainedpublishedIndicates whether updates and inserts that don't conform to the result set generated by a SELECT statement are permitted for Paradox and dBASE tables
ConstraintspublishedSpecifies record-level constraints that must be met when editing the data.
CurrentRecordprotectedIndicates the index of the current record in the internal cache of record buffers.
DatabasepublicIdentifies the database component for which this dataset represents one or more tables.
DatabaseNamepublishedSpecifies the name of the database associated with this dataset.
DataLinkprotected
DataSetFieldpublicIndicates the persistent TDataSetField object that owns a nested dataset.
DataSourcepublishedSpecifies the data source component from which to extract current field values to use with same-name parameters in the query's SQL statement.
DBFlagsprotectedKeeps track of the commands this dataset has active with the database.
DBHandlepublicSpecifies the Borland Database Engine (BDE) database handle for the dataset.
DBLocalepublicIdentifies the Borland Database Engine (BDE) language driver for the dataset component.
DBSessionpublicIdentifies the database session component associated with this dataset.
DesignerpublicReturns a pointer to the DataSet designer for the dataset.
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.
ExpIndexpublicIndicates whether a dataset is using a dBASE expression index.
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.
FilterpublishedSpecifies the text of the current filter for a dataset.
FilteredpublishedSpecifies whether or not filtering is active for a dataset.
FilterOptionspublishedSpecifies 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.
HandlepublicSpecifies the Borland Database Engine (BDE) cursor handle for the dataset.
InternalCalcFieldsprotectedIndicates whether the dataset includes internally calculated fields.
IOBufferSizeprotected
IsUniDirectionalpublicIndicates whether the dataset is unidirectional.
KeySizepublicSpecifies the size of the key for the current index of the dataset.
LocalpublicIndicates whether a query references one or more Paradox or dBASE tables rather than SQL tables on a remote server.
LocalepublicIdentifies the Borland Database Engine (BDE) language driver for the dataset.
ModifiedpublicIndicates whether the active record is modified.
NamepublishedSpecifies the name of the component as referenced in code.
NestedDataSetClassprotectedIndicates the class type to use when creating nested datasets.
NestedDataSetsprotectedLists all nested datasets.
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.
OnDeleteErrorpublishedOccurs when an application attempts to delete a record and an exception is raised.
OnEditErrorpublishedOccurs when an application attempts to modify or insert a record and an exception is raised.
OnFilterRecordpublishedOccurs only when a record is fetched from a DB or when the Filtered property is set to True.
OnNewRecordpublishedOccurs when an application inserts or appends a new dataset record.
OnPostErrorpublishedOccurs when an application attempts to modify or insert a record and an exception is raised.
OwnerpublicIndicates the component that is responsible for streaming and freeing this component.
ParamCheckpublishedSpecifies whether the parameter list for a query is regenerated if the SQL property changes at runtime.
ParamCountpublicIndicates the current number of parameters for the query.
ParamspublishedContains the parameters for a query's SQL statement.
PreparedpublicDetermines whether or not a query is prepared for execution.
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.
RequestLivepublishedRequests an updatable query result set from the database.
RowsAffectedpublicReturns the number of rows operated upon by the latest query execution.
SessionNamepublishedIdentifies the name of the session with which this dataset is associated.
SparseArrayspublicDetermines whether a unique TField object is created for each element of an array field.
SQLpublishedContains the text of the SQL statement to execute for the query.
SQLBinarypublicPoints to the binary data stream that represents an SQL query statement or result set.
StatepublicIndicates the current operating mode of the dataset.
StmtHandlepublicSpecifies the Borland Database Engine (BDE) statement handle for the dataset.
TagpublishedStores a NativeInt integral value as a part of a component.
TextpublicPoints to the actual text of the SQL query passed to the Borland Database Engine (BDE).
UniDirectionalpublishedDetermines whether or not Borland Database Engine (BDE) bidirectional cursors are enabled for a query's result set.
UpdateModepublishedDetermines how the Borland Database Engine (BDE) finds records when updating to an SQL database.
UpdateObjectpublishedSpecifies the update object component used to update a read-only result set when cached updates are enabled.
UpdateRecordTypespublicSpecifies the type of records visible in a dataset when cached updates are enabled.
UpdatesPendingpublicIndicates whether the cached updates buffer contains records that are not yet applied.
VCLComObjectpublicRepresents information used internally by components that support COM.