Bde.DBTables.TQuery Properties
From RAD Studio API Documentation
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.
AfterCancel published Occurs after an application completes a request to cancel modifications to the active record.
AfterClose published Occurs after an application closes a dataset.
AfterDelete published Occurs after an application deletes a record.
AfterEdit published Occurs after an application starts editing a record.
AfterInsert published Occurs after an application inserts a new record.
AfterOpen published Occurs after an application completes opening a dataset and before any data access occurs.
AfterPost published Occurs after an application writes the active record to the database or change log and returns to browse state.
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 published Determines when the OnCalcFields event is triggered and when lookup field values are calculated.
AutoRefresh published Specifies whether server-generated field values are refetched automatically.
BeforeCancel published Occurs before an application executes a request to cancel changes to the active record.
BeforeClose published Occurs immediately before the dataset closes.
BeforeDelete published Occurs before an application attempts to delete the active record.
BeforeEdit published Occurs before an application enters edit mode for the active record.
BeforeInsert published Occurs before an application enters insert mode.
BeforeOpen published Occurs before an application executes a request to open a dataset.
BeforePost published Occurs before an application posts changes for the active record to the database or change log.
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.
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.
CacheBlobs public Determines whether BLOB fields are cached in memory.
CachedUpdates published Specifies whether cached updates are enabled for a dataset.
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
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.
Constrained published Indicates whether updates and inserts that don't conform to the result set generated by a SELECT statement are permitted for Paradox and dBASE tables
Constraints published Specifies record-level constraints that must be met when editing the data.
CurrentRecord protected Indicates the index of the current record in the internal cache of record buffers.
Database public Identifies the database component for which this dataset represents one or more tables.
DatabaseName published Specifies the name of the database associated with this dataset.
DataLink protected
DataSetField public Indicates the persistent TDataSetField object that owns a nested dataset.
DataSource published Specifies the data source component from which to extract current field values to use with same-name parameters in the query's SQL statement.
DBFlags protected Keeps track of the commands this dataset has active with the database.
DBLocale public Identifies the Borland Database Engine (BDE) language driver for the dataset component.
DBSession public Identifies the database session component associated with this dataset.
DesignInfo public Contains information used by the Form designer.
Eof public Indicates whether a dataset is positioned at the last record.
ExpIndex public Indicates whether a dataset is using a dBASE expression index.
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 published Specifies the text of the current filter for a dataset.
Filtered published Specifies whether or not filtering is active for a dataset.
FilterOptions published 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.
InternalCalcFields protected Indicates whether the dataset includes internally calculated fields.
IOBufferSize protected
IsUniDirectional public Indicates whether the dataset is unidirectional.
KeySize public Specifies the size of the key for the current index of the dataset.
Local public Indicates whether a query references one or more Paradox or dBASE tables rather than SQL tables on a remote server.
Modified public Indicates whether the active record is modified.
Name published Specifies the name of the component as referenced in code.
NestedDataSetClass protected Indicates the class type to use when creating nested datasets.
NestedDataSets protected Lists all nested datasets.
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.
OnDeleteError published Occurs when an application attempts to delete a record and an exception is raised.
OnEditError published Occurs when an application attempts to modify or insert a record and an exception is raised.
OnFilterRecord published Occurs only when a record is fetched from a DB or when the Filtered property is set to True.
OnNewRecord published Occurs when an application inserts or appends a new dataset record.
OnPostError published Occurs when an application attempts to modify or insert a record and an exception is raised.
Owner public Indicates the component that is responsible for streaming and freeing this component.
ParamCheck published Specifies whether the parameter list for a query is regenerated if the SQL property changes at runtime.
ParamCount public Indicates the current number of parameters for the query.
Params published Contains the parameters for a query's SQL statement.
Prepared public Determines whether or not a query is prepared for execution.
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.
RequestLive published Requests an updatable query result set from the database.
RowsAffected public Returns the number of rows operated upon by the latest query execution.
SessionName published Identifies the name of the session with which this dataset is associated.
SparseArrays public Determines whether a unique TField object is created for each element of an array field.
SQLBinary public Points to the binary data stream that represents an SQL query statement or result set.
State public Indicates the current operating mode of the dataset.
StmtHandle public Specifies the Borland Database Engine (BDE) statement handle for the dataset.
UniDirectional published Determines whether or not Borland Database Engine (BDE) bidirectional cursors are enabled for a query's result set.
UpdateMode published Determines how the Borland Database Engine (BDE) finds records when updating to an SQL database.
UpdateObject published Specifies the update object component used to update a read-only result set when cached updates are enabled.
UpdateRecordTypes public Specifies the type of records visible in a dataset when cached updates are enabled.
UpdatesPending public Indicates whether the cached updates buffer contains records that are not yet applied.
VCLComObject public Represents information used internally by components that support COM.