TFDQuery用法01

FireDAC.Comp.Client.TFDQuery

TFDQuery

Delphi

TFDQuery=class(TFDCustomQuery)

属性说明:

Activepublished数据集是否打开,Action为True可以打开数据集。
ActiveRecordprotected数据集中当前记录的索引
ActiveStoredUsagepublished是否把Active属性存储到DFM文件中
ActualDetailFieldspublic
Adapterpublic指定数据adapter.
AggFieldspublic聚合字段
AggregatespublishedThe collection of client-side aggregates defined for the dataset.
AggregatesActivepublishedControls the automatic calculation of aggregate values.
AutoCalcFieldspublishedDetermines when the OnCalcFields event is triggered and when lookup field values are calculated.
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.
CachedUpdatespublishedSpecifies whether the dataset will log changes to the data without immediately applying of them to the database.
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
ChangeAlerterpublishedChange alerter associated with your dataset.
ChangeAlertNamepublishedOptional name of the change notification.
ChangeCountpublicGets the number of changes in the change log.
ClientCursorpublic
CloneSourcepublicGets the dataset (if any) with which this dataset shares data.
CommandpublicThe reference to a command, used to execute / open queries.
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 FireDAC connection component to use.
ConnectionNamepublishedSpecifies the FireDAC connection to use by its name.
ConstraintspublishedSpecifies record-level constraints that must be met when editing the data.
ConstraintsEnabledpublishedSpecifies whether the dataset performs constraint checking.
CurrentRecordprotectedIndicates the index of the current record in the internal cache of record buffers.
DatapublicRepresents the data of the dataset, allowing to fully copy data from one dataset into another.
DataSetFieldpublicIndicates the persistent TDataSetField object that owns a nested dataset.
DataSourcepublicSpecifies the data source object from which the associated dataset to get matching field values to the details dataset parameters.
DatSManagerpublicReturns the reference to the internal data storage manager.
DeltapublicRepresents the changed records of the dataset.
DesignerpublicReturns a pointer to the DataSet designer for the dataset.
DesignInfopublicContains information used by the Form designer.
DetailFieldspublishedGets or sets the fields in the detail dataset that are used to establish a master-detail relationship with this dataset.
DisposedprotectedDisposed is a read-only property that shows the current state of this object.
Encoderpublic
EofpublicIndicates whether a dataset is positioned at the last record.
Existspublic
FetchOptionspublished
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.
FieldOptionspublishedSpecifies 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.
FilterChangespublishedSpecifies what types of changed records must be visible (accessible though the navigation interface) in the dataset.
FilteredpublishedSpecifies whether or not filtering is active for a dataset.
FilteredDatapublicRepresents the currently visible dataset data.
FilterOptionspublishedSpecifies whether or not filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records.
FormatOptionspublished
FoundpublicIndicates whether or not moving to a different record is successful.
GroupingLevelpublicReturns the depth of grouping support provided by the current index.
IndexDefspublicReturns the index definitions for the dataset.
IndexespublishedLists all client indexes that apply to the dataset.
IndexesActivepublishedControls the automatic maintenance of indexes.
IndexFieldCountpublicReturns the number of fields that make up the current index.
IndexFieldNamespublishedLists the field names to use as an index.
IndexFieldspublicReturns the fields that make up the current index.
IndexNamepublishedGets or sets the current index for the dataset by its name.
InternalCalcFieldsprotectedIndicates whether the dataset includes internally calculated fields.
IsUniDirectionalpublicIndicates whether the dataset is unidirectional.
KeyExclusivepublicControls the exclusion of the upper and lower boundaries of a range.
KeyFieldCountpublicControls the number of indexed field values to use for key search or range setup.
LocalIndexNamepublic
LocalSQLpublishedThe reference to a Local SQL engine.
MacroCountpublic
Macrospublished
MasterFieldspublishedGets/sets fields in the master dataset, used to establish a master-detail relationship with this dataset.
MasterLinkpublicReturns the data link object servicing the connection with the master dataset.
MasterSourcepublishedGets/sets a master data source, used to establish a master-detail relationship with this 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.
OptionsIntfpublic
OptionsIntfImplprotected
OwnerpublicIndicates the component that is responsible for streaming and freeing this component.
ParamBindModeprotected
ParamCountpublic
Paramspublished
ParentDataSetpublicReturns a reference to the parent dataset, if this one is nested.
PointedConnectionpublicThe actual connection object.
PreparedpublicGets or sets command prepare for execution status.
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.
ResourceOptionspublished
RowErrorpublicReturns an exception object associated with the current dataset record.
RowsAffectedpublic
SavePointpublicGets/sets the change log version number.
SchemaAdapterpublishedGets or sets a reference to a schema adapter as a Centralized Cached Updates log.
ServerEditRequestpublicUsed by TFDDataMove to directly edit the DBMS data.
SortViewprotected
SourceEOFpublicSpecifies if there are no more records to fetch from the current cursor.
SourceViewpublicSpecifies the reference to the DatS view object whose rows the dataset is navigating.
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.
StatepublicIndicates the current operating mode of the dataset.
TablepublicSpecifies the reference to the DatS table object, representing the internal data storage.
TagpublishedStores a NativeInt integral value as a part of a component.
TextpublicPoints to the actual text of the SQL query passed to the DBMS CLI.
TransactionpublishedGets / Sets a reference to transaction objects.
UpdateObjectpublished
UpdateOptionspublished
Updatesprotected
UpdatesPendingpublicSpecifies whether the change log is not empty.
UpdateTransactionpublishedGets / Sets a reference to transaction objects.
VCLComObjectpublicRepresents information used internally by components that support COM.
ViewpublicSpecifies the reference to the base DatS view object.




联系电话:
020-00000000
联系电话:
020-00000000
联系电话:
020-12345678