Data.Win.ADODB.TADOTable Properties

From RAD Studio API Documentation
Jump to: navigation, search

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.
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.
CacheSizepublishedSpecifies the size of the cache for the 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.
CommandprotectedProvides access to the internal command object that executes commands for the dataset.
CommandTextprotectedSpecifies a command to be executed.
CommandTimeoutpublishedSpecifies amount of time to attempt execution of a command.
CommandTypeprotectedSpecifies the type of command to execute.
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.
ConnectionpublishedSpecifies the ADO connection component to use.
ConnectionStringpublishedSpecifies the connection information for the data store.
ConstraintsprotectedSpecifies 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.
CursorLocationpublishedSpecifies whether the cursor for the connection is client-side or server-side.
CursorTypepublishedSpecifies type of cursor an ADO dataset uses.
DataSetFieldpublicIndicates the persistent TDataSetField object that owns a nested dataset.
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.
EnableBCDpublishedSpecifies whether to treat numeric fields as floating-point or BCD.
EofpublicIndicates whether a dataset is positioned at the last record.
ExecuteOptionspublishedSpecifies the characteristics of a command execution.
FieldCountpublicIndicates the number of field components associated with the dataset.
FieldDefListpublicPoints to the list of field definitions for the dataset.
FieldDefsprotectedPoints 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.
FilterGrouppublicFilters a recordset based on row update status.
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.
IndexDefspublicContains the definitions of the indexes for the current table.
IndexFieldCountpublicIndicates the number of fields that comprise the current key.
IndexFieldNamespublishedLists the columns to use for a persistent sort of the recordset.
IndexFieldspublicRetrieves or sets a field for an index.
IndexNamepublishedSpecifies the currently active index.
InternalCalcFieldsprotectedIndicates whether the dataset includes internally calculated fields.
IsUniDirectionalpublicIndicates whether the dataset is unidirectional.
LockTypepublishedSpecifies the lock type to use when opening a dataset.
MarshalOptionspublishedSpecifies which records are marshaled back to the server.
MasterDataLinkprotectedManages the relationship between the ADO dataset and a master table.
MasterFieldspublishedSpecifies field or fields on which a Master-Detail link is based.
MasterSourcepublishedSpecifies the data source component used for a Master-Detail relationship.
MaxRecordspublishedSpecifies how many rows to return in a result set.
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.
ObjectViewpublicSpecifies 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.
ParamCheckprotectedSpecifies whether the parameter list for an ADO dataset component is regenerated if the SQL changes at runtime.
ParametersprotectedContains the collection of parameters for an SQL statement.
PreparedprotectedSpecifies whether the command is prepared before execution.
PropertiespublicProperties is the implementation of the Properties Collection object.
ReadOnlypublishedSpecifies whether the data retrieved is read-only.
RecNopublicIndicates the active record number in the dataset.
RecordCountpublicIndicates the total number of records associated with the dataset.
RecordsetpublicProvides direct access to the ADO Recordset object.
RecordsetStatepublicIndicates the current state of the ADO dataset component.
RecordSizepublicIndicates the size of a record in the dataset.
RecordStatuspublicIndicates the status of the current row.
SortpublicSpecifies the sort order of the recordset.
SparseArrayspublicDetermines whether a unique TField object is created for each element of an array field.
StatepublicIndicates the current operating mode of the dataset.
StoreDefsprotectedSpecifies whether field definitions are stored with the ADO dataset.
TableDirectpublishedSpecifies how the table is referenced.
TableNamepublishedIndicates the base table operated on.
TagpublishedStores a NativeInt integral value as a part of a component.
VCLComObjectpublicRepresents information used internally by components that support COM.