Data.Win.ADODB.TADOQuery Properties

• Up to Parent: TADOQuery

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.
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.
CacheSize	published	Specifies the size of the cache for the 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
Command	protected	Provides access to the internal command object that executes commands for the dataset.
CommandText	protected	Specifies a command to be executed.
CommandTimeout	published	Specifies amount of time to attempt execution of a command.
CommandType	protected	Specifies the type of command to execute.
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.
Connection	published	Specifies the ADO connection component to use.
ConnectionString	published	Specifies the connection information for the data store.
Constraints	protected	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.
CursorLocation	published	Specifies whether the cursor for the connection is client-side or server-side.
CursorType	published	Specifies type of cursor an ADO dataset uses.
DataSetField	public	Indicates the persistent TDataSetField object that owns a nested dataset.
DataSource	published
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.
EnableBCD	published	Specifies whether to treat numeric fields as floating-point or BCD.
Eof	public	Indicates whether a dataset is positioned at the last record.
ExecuteOptions	published	Specifies the characteristics of a command execution.
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	protected	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.
FilterGroup	public	Filters a recordset based on row update status.
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.
IndexDefs	protected	Contains the definitions of the indexes for the current table.
IndexFieldCount	public	Indicates the number of fields that comprise the current key.
IndexFieldNames	protected	Lists the columns to use for a persistent sort of the recordset.
IndexFields	public	Retrieves or sets a field for an index.
IndexName	public	Specifies the currently active index.
InternalCalcFields	protected	Indicates whether the dataset includes internally calculated fields.
IOBufferSize	protected
IsUniDirectional	public	Indicates whether the dataset is unidirectional.
LockType	published	Specifies the lock type to use when opening a dataset.
MarshalOptions	published	Specifies which records are marshaled back to the server.
MasterDataLink	protected	Manages the relationship between the ADO dataset and a master table.
MasterFields	protected	Specifies field or fields on which a Master-Detail link is based.
MaxRecords	published	Specifies how many rows to return in a result set.
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	public	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 an ADO dataset component is regenerated if the SQL changes at runtime.
Parameters	published	Contains the collection of parameters for an SQL statement.
Prepared	published	Specifies whether the command is prepared before execution.
Properties	public	Properties is the implementation of the Properties Collection object.
RecNo	public	Indicates the active record number in the dataset.
RecordCount	public	Indicates the total number of records associated with the dataset.
Recordset	public	Provides direct access to the ADO Recordset object.
RecordsetState	public	Indicates the current state of the ADO dataset component.
RecordSize	public	Indicates the size of a record in the dataset.
RecordStatus	public	Indicates the status of the current row.
Reserved	protected
RowsAffected	public	Returns the number of rows operated upon by the latest query execution.
Sort	public	Specifies the sort order of the recordset.
SparseArrays	public	Determines whether a unique TField object is created for each element of an array field.
SQL	published	Contains the text of the SQL statement to execute for the ADO query.
State	public	Indicates the current operating mode of the dataset.
StoreDefs	protected	Specifies whether field definitions are stored with the ADO 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.