Data.Win.ADODB.TADOQuery Properties

• Up to Parent: TADOQuery

Show Protected Members

Active	public	Specifies whether or not a dataset is open.
ActiveRecord	protected	Indicates the index of the active record in the internal cache of records.
AfterCancel	public	Occurs after an application completes a request to cancel modifications to the active record.
AfterClose	public	Occurs after an application closes a dataset.
AfterDelete	public	Occurs after an application deletes a record.
AfterEdit	public	Occurs after an application starts editing a record.
AfterInsert	public	Occurs after an application inserts a new record.
AfterOpen	public	Occurs after an application completes opening a dataset and before any data access occurs.
AfterPost	public	Occurs after an application writes the active record to the database or change log and returns to browse state.
AfterRefresh	public	Occurs after an application refreshes the data in the dataset.
AfterScroll	public	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.
BeforeCancel	public	Occurs before an application executes a request to cancel changes to the active record.
BeforeClose	public	Occurs immediately before the dataset closes.
BeforeDelete	public	Occurs before an application attempts to delete the active record.
BeforeEdit	public	Occurs before an application enters edit mode for the active record.
BeforeInsert	public	Occurs before an application enters insert mode.
BeforeOpen	public	Occurs before an application executes a request to open a dataset.
BeforePost	public	Occurs before an application posts changes for the active record to the database or change log.
BeforeRefresh	public	Occurs immediately before an application refreshes the data in the dataset.
BeforeScroll	public	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.
Command	protected	Provides access to the internal command object that executes commands for the dataset.
CommandText	protected	Specifies a command to be executed.
CommandTimeout	protected	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	protected
DefaultFields	public	Indicates whether a dataset's underlying field components are generated dynamically when the dataset is opened.
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.
EnableBCD	public	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	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.
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.
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.
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
OnCalcFields	public	Occurs when an application recalculates calculated fields.
OnDeleteError	public	Occurs when an application attempts to delete a record and an exception is raised.
OnEditError	public	Occurs when an application attempts to modify or insert a record and an exception is raised.
OnFilterRecord	public	Occurs each time a different record in the dataset becomes the active record and filtering is enabled.
OnNewRecord	public	Occurs when an application inserts or appends a new dataset record.
OnPostError	public	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	protected	Specifies whether the parameter list for an ADO dataset component is regenerated if the SQL changes at runtime.
Parameters	protected	Contains the collection of parameters for an SQL statement.
Prepared	protected	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 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	For internal use only.
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.