TADOQuery Members

The following tables list the members exposed by TADOQuery.

	Name	Description
	FComponentStyle	FComponentStyle is the field of the ComponentStyle read-only property.

Protected Methods

	Name	Description
	_AddRef	Called when an application uses a component interface.
	_Release	Called when an application releases a component interface.
	ActivateBuffers	This is ActivateBuffers, a member of class TDataSet.
	ActivateTextFilter	This is ActivateTextFilter, a member of class TCustomADODataSet.
	AllocRecordBuffer	This is AllocRecordBuffer, a member of class TCustomADODataSet.
	AllocRecordBuffer	This is AllocRecordBuffer, a member of class TDataSet.
	AssignTo	Copies the properties of an object to a destination object.
	BindFields	This is BindFields, a member of class TDataSet.
	BlockReadNext	This is BlockReadNext, a member of class TDataSet.
	BookmarkAvailable	This is BookmarkAvailable, a member of class TDataSet.
	CalculateFields	This is CalculateFields, a member of class TDataSet.
	ChangeName	Sets the private, internal storage for the Name property to the string passed in NewName.
	CheckActive	This is CheckActive, a member of class TCustomADODataSet.
	CheckActive	This is CheckActive, a member of class TDataSet.
	CheckBiDirectional	This is CheckBiDirectional, a member of class TDataSet.
	CheckFieldCompatibility	This is CheckFieldCompatibility, a member of class TCustomADODataSet.
	CheckFieldCompatibility	This is CheckFieldCompatibility, a member of class TDataSet.
	CheckInactive	This is CheckInactive, a member of class TDataSet.
	ClearBuffers	This is ClearBuffers, a member of class TDataSet.
	ClearCalcFields	This is ClearCalcFields, a member of class TCustomADODataSet.
	ClearCalcFields	This is ClearCalcFields, a member of class TDataSet.
	CloseBlob	This is CloseBlob, a member of class TDataSet.
	CloseCursor	This is CloseCursor, a member of class TDataSet.
	ConnectionPoint	This is ConnectionPoint, a member of class TCustomADODataSet.
	CreateFields	This is CreateFields, a member of class TDataSet.
	CreateNestedDataSet	This is CreateNestedDataSet, a member of class TDataSet.
	DataConvert	This is DataConvert, a member of class TDataSet.
	DataEvent	This is DataEvent, a member of class TCustomADODataSet.
	DataEvent	This is DataEvent, a member of class TDataSet.
	DeactivateFilters	This is DeactivateFilters, a member of class TCustomADODataSet.
	DefChanged	This is DefChanged, a member of class TCustomADODataSet.
	DefChanged	This is DefChanged, a member of class TDataSet.
	DefineProperties	Designates methods for storing an object's unpublished data on a stream such as a form file.
	DefineProperties	Designates methods for storing an object's unpublished data on a stream such as a form file.
	DefineProperties	Provides an interface for a method that reads and writes otherwise unpublished data.
	DestroyFields	This is DestroyFields, a member of class TDataSet.
	DestroyLookupCursor	This is DestroyLookupCursor, a member of class TCustomADODataSet.
	DoAfterCancel	This is DoAfterCancel, a member of class TDataSet.
	DoAfterClose	This is DoAfterClose, a member of class TDataSet.
	DoAfterDelete	This is DoAfterDelete, a member of class TDataSet.
	DoAfterEdit	This is DoAfterEdit, a member of class TDataSet.
	DoAfterInsert	This is DoAfterInsert, a member of class TDataSet.
	DoAfterOpen	This is DoAfterOpen, a member of class TDataSet.
	DoAfterPost	This is DoAfterPost, a member of class TDataSet.
	DoAfterRefresh	This is DoAfterRefresh, a member of class TDataSet.
	DoAfterScroll	This is DoAfterScroll, a member of class TDataSet.
	DoBeforeCancel	This is DoBeforeCancel, a member of class TDataSet.
	DoBeforeClose	This is DoBeforeClose, a member of class TDataSet.
	DoBeforeDelete	This is DoBeforeDelete, a member of class TDataSet.
	DoBeforeEdit	This is DoBeforeEdit, a member of class TDataSet.
	DoBeforeInsert	This is DoBeforeInsert, a member of class TDataSet.
	DoBeforeOpen	This is DoBeforeOpen, a member of class TDataSet.
	DoBeforePost	This is DoBeforePost, a member of class TDataSet.
	DoBeforeRefresh	This is DoBeforeRefresh, a member of class TDataSet.
	DoBeforeScroll	This is DoBeforeScroll, a member of class TDataSet.
	DoOnCalcFields	This is DoOnCalcFields, a member of class TDataSet.
	DoOnNewRecord	This is DoOnNewRecord, a member of class TCustomADODataSet.
	DoOnNewRecord	This is DoOnNewRecord, a member of class TDataSet.
	EnableEvents	This is EnableEvents, a member of class TCustomADODataSet.
	EndOfRecordset	This is EndOfRecordset, a member of class TCustomADODataSet.
	FetchComplete	This is FetchComplete, a member of class TCustomADODataSet.
	FetchProgress	This is FetchProgress, a member of class TCustomADODataSet.
	FieldByNumber	This is FieldByNumber, a member of class TDataSet.
	FieldChangeComplete	This is FieldChangeComplete, a member of class TCustomADODataSet.
	FindRecord	This is FindRecord, a member of class TCustomADODataSet.
	FindRecord	This is FindRecord, a member of class TDataSet.
	FreeFieldBuffers	This is FreeFieldBuffers, a member of class TDataSet.
	FreeRecordBuffer	This is FreeRecordBuffer, a member of class TCustomADODataSet.
	FreeRecordBuffer	This is FreeRecordBuffer, a member of class TDataSet.
	GetActiveRecBuf	This is GetActiveRecBuf, a member of class TCustomADODataSet.
	GetAggFieldsClass	This is GetAggFieldsClass, a member of class TDataSet.
	GetAggRecordCount	This is GetAggRecordCount, a member of class TDataSet.
	GetAggregateValue	This is GetAggregateValue, a member of class TDataSet.
	GetBookmarkData	This is GetBookmarkData, a member of class TCustomADODataSet.
	GetBookmarkData	This is GetBookmarkData, a member of class TDataSet.
	GetBookmarkFlag	This is GetBookmarkFlag, a member of class TCustomADODataSet.
	GetBookmarkFlag	This is GetBookmarkFlag, a member of class TDataSet.
	GetBookmarkStr	This is GetBookmarkStr, a member of class TDataSet.
	GetCalcFields	This is GetCalcFields, a member of class TDataSet.
	GetCanModify	This is GetCanModify, a member of class TCustomADODataSet.
	GetCanModify	This is GetCanModify, a member of class TDataSet.
	GetCheckConstraintsClass	This is GetCheckConstraintsClass, a member of class TDataSet.
	GetChildOwner	Returns the owner of a child component being read from a stream.
	GetChildParent	Returns the parent, or if there is no parent, returns the owner of a child component being read from a stream.
	GetChildren	Enumerates all child components.
	GetChildren	Enumerates all child components.
	GetCommandText	This is GetCommandText, a member of class TCustomADODataSet.
	GetDataSource	This is GetDataSource, a member of class TCustomADODataSet.
	GetDataSource	This is GetDataSource, a member of class TDataSet.
	GetFieldClass	This is the overview for the GetFieldClass method overload.
	GetFieldDefListClass	This is GetFieldDefListClass, a member of class TDataSet.
	GetFieldDefsClass	This is GetFieldDefsClass, a member of class TDataSet.
	GetFieldFullName	This is GetFieldFullName, a member of class TDataSet.
	GetFieldListClass	This is GetFieldListClass, a member of class TDataSet.
	GetFieldsClass	This is GetFieldsClass, a member of class TDataSet.
	GetIDsOfNames	Maps a single member and an optional set of argument names to a corresponding set of integer dispatch identifiers (dispIDs).
	GetIndexDefs	This is GetIndexDefs, a member of class TDataSet.
	GetIndexDefsClass	This is GetIndexDefsClass, a member of class TDataSet.
	GetIsIndexField	This is GetIsIndexField, a member of class TDataSet.
	GetLookupListClass	This is GetLookupListClass, a member of class TDataSet.
	GetNextRecord	This is GetNextRecord, a member of class TDataSet.
	GetNextRecords	This is GetNextRecords, a member of class TDataSet.
	GetOwner	Returns the owner of a component.
	GetOwner	Returns the owner of an object.
	GetParamsClass	This is GetParamsClass, a member of class TDataSet.
	GetPriorRecord	This is GetPriorRecord, a member of class TDataSet.
	GetPriorRecords	This is GetPriorRecords, a member of class TDataSet.
	GetRecNo	This is GetRecNo, a member of class TCustomADODataSet.
	GetRecNo	This is GetRecNo, a member of class TDataSet.
	GetRecord	This is GetRecord, a member of class TCustomADODataSet.
	GetRecord	This is GetRecord, a member of class TDataSet.
	GetRecordCount	This is GetRecordCount, a member of class TCustomADODataSet.
	GetRecordCount	This is GetRecordCount, a member of class TDataSet.
	GetRecordSize	This is GetRecordSize, a member of class TCustomADODataSet.
	GetRecordSize	This is GetRecordSize, a member of class TDataSet.
	GetStateFieldValue	This is GetStateFieldValue, a member of class TCustomADODataSet.
	GetStateFieldValue	This is GetStateFieldValue, a member of class TDataSet.
	GetTypeInfo	Retrieves the type information for an object.
	GetTypeInfoCount	Returns the number of type information interfaces that an object provides (either 0 or 1).
	InitFieldDefs	This is InitFieldDefs, a member of class TDataSet.
	InitFieldDefsFromFields	This is InitFieldDefsFromFields, a member of class TDataSet.
	InitOleDBAccess	This is InitOleDBAccess, a member of class TCustomADODataSet.
	InitRecord	This is InitRecord, a member of class TDataSet.
	InternalAddRecord	This is InternalAddRecord, a member of class TCustomADODataSet.
	InternalAddRecord	This is InternalAddRecord, a member of class TDataSet.
	InternalCancel	This is InternalCancel, a member of class TCustomADODataSet.
	InternalCancel	This is InternalCancel, a member of class TDataSet.
	InternalClose	This is InternalClose, a member of class TCustomADODataSet.
	InternalClose	This is InternalClose, a member of class TDataSet.
	InternalDelete	This is InternalDelete, a member of class TCustomADODataSet.
	InternalDelete	This is InternalDelete, a member of class TDataSet.
	InternalEdit	This is InternalEdit, a member of class TCustomADODataSet.
	InternalEdit	This is InternalEdit, a member of class TDataSet.
	InternalFirst	This is InternalFirst, a member of class TCustomADODataSet.
	InternalFirst	This is InternalFirst, a member of class TDataSet.
	InternalGetRecord	This is InternalGetRecord, a member of class TCustomADODataSet.
	InternalGotoBookmark	This is InternalGotoBookmark, a member of class TCustomADODataSet.
	InternalGotoBookmark	This is InternalGotoBookmark, a member of class TDataSet.
	InternalHandleException	This is InternalHandleException, a member of class TCustomADODataSet.
	InternalHandleException	This is InternalHandleException, a member of class TDataSet.
	InternalInitFieldDefs	This is InternalInitFieldDefs, a member of class TCustomADODataSet.
	InternalInitFieldDefs	This is InternalInitFieldDefs, a member of class TDataSet.
	InternalInitRecord	This is InternalInitRecord, a member of class TCustomADODataSet.
	InternalInitRecord	This is InternalInitRecord, a member of class TDataSet.
	InternalInsert	This is InternalInsert, a member of class TCustomADODataSet.
	InternalInsert	This is InternalInsert, a member of class TDataSet.
	InternalLast	This is InternalLast, a member of class TCustomADODataSet.
	InternalLast	This is InternalLast, a member of class TDataSet.
	InternalOpen	This is InternalOpen, a member of class TCustomADODataSet.
	InternalOpen	This is InternalOpen, a member of class TDataSet.
	InternalPost	This is InternalPost, a member of class TCustomADODataSet.
	InternalPost	This is InternalPost, a member of class TDataSet.
	InternalRefresh	This is InternalRefresh, a member of class TCustomADODataSet.
	InternalRefresh	This is InternalRefresh, a member of class TDataSet.
	InternalRequery	This is InternalRequery, a member of class TCustomADODataSet.
	InternalSetSort	This is InternalSetSort, a member of class TCustomADODataSet.
	InternalSetToRecord	This is InternalSetToRecord, a member of class TCustomADODataSet.
	InternalSetToRecord	This is InternalSetToRecord, a member of class TDataSet.
	Invoke	Provides access to Automation properties and methods when the component wraps an Automation object.
	IsCursorOpen	This is IsCursorOpen, a member of class TCustomADODataSet.
	IsCursorOpen	This is IsCursorOpen, a member of class TDataSet.
	Loaded	Initializes the component after the form file has been read into memory.
	Loaded	Initializes the component after the form file has been read into memory.
	Loaded	Initializes the component after the form file has been read into memory.
	LocateRecord	This is LocateRecord, a member of class TCustomADODataSet.
	MasterChanged	This is MasterChanged, a member of class TCustomADODataSet.
	MasterDisabled	This is MasterDisabled, a member of class TCustomADODataSet.
	MoveComplete	This is MoveComplete, a member of class TCustomADODataSet.
	Notification	Forwards notification messages to all owned components.
	OpenCursor	This is OpenCursor, a member of class TCustomADODataSet.
	OpenCursor	This is OpenCursor, a member of class TDataSet.
	OpenCursorComplete	This is OpenCursorComplete, a member of class TDataSet.
	OpenParentDataSet	This is OpenParentDataSet, a member of class TDataSet.
	PaletteCreated	Responds when the component is created from the component palette.
	PrepareCursor	This is PrepareCursor, a member of class TCustomADODataSet.
	PSEndTransaction	Ends a transaction that was started by a call to PSStartTransaction.
	PSEndTransaction	Ends a transaction that was started by a call to PSStartTransaction.
	PSExecute	Executes the SQL command associated with the dataset.
	PSExecute	Executes the SQL command associated with the dataset.
	PSExecuteStatement	This is PSExecuteStatement, a member of class TCustomADODataSet.
	PSExecuteStatement	This is the overview for the PSExecuteStatement method overload.
	PSGetAttributes	Returns information that is stored in data packets as Name/Value pairs.
	PSGetAttributes	Returns information that is stored in data packets as Name/Value pairs.
	PSGetCommandText	Gets the SQL command to be executed by PSExecute.
	PSGetCommandText	Gets the SQL command to be executed by PSExecute.
	PSGetCommandTextW	This is PSGetCommandTextW, a member of class TDataSet.
	PSGetCommandType	Gets the command type to be executed by PSExecute.
	PSGetCommandType	Gets the command type to be executed by PSExecute.
	PSGetDefaultOrder	Returns the definition of an index that imposes the default order on the data included in data packets.
	PSGetDefaultOrder	Returns the definition of an index that imposes the default order on the data included in data packets.
	PSGetIndexDefs	Returns the definitions of all specified indexes defined for the dataset.
	PSGetIndexDefs	Returns the definitions of all specified indexes defined for the dataset.
	PSGetKeyFields	Returns the names of all fields required to uniquely identify records in the data packet.
	PSGetKeyFields	Returns the names of all fields required to uniquely identify records in the data packet.
	PSGetKeyFieldsW	This is PSGetKeyFieldsW, a member of class TDataSet.
	PSGetParams	Returns the current parameter values of the dataset.
	PSGetParams	Returns the current parameter values of the dataset.
	PSGetQuoteChar	Returns the character or characters to use in generated SQL statements to enclose quoted strings.
	PSGetQuoteChar	Returns the character or characters to use in generated SQL statements to enclose quoted strings.
	PSGetQuoteCharW	This is PSGetQuoteCharW, a member of class TDataSet.
	PSGetTableName	Returns the name of the dataset table that appears in generated SQL statements.
	PSGetTableName	Returns the name of the dataset table that appears in generated SQL statements.
	PSGetTableNameW	This is PSGetTableNameW, a member of class TDataSet.
	PSGetUpdateException	Generates an EUpdateError object based on another exception object.
	PSGetUpdateException	Generates an EUpdateError object based on another exception object.
	PSInTransaction	Indicates whether actions against the dataset occur in the context of a transaction.
	PSInTransaction	Indicates whether actions against the dataset occur in the context of a transaction.
	PSIsSQLBased	Indicates whether the dataset includes native SQL support.
	PSIsSQLBased	Indicates whether the dataset includes native SQL support.
	PSIsSQLSupported	Indicates whether the dataset can execute SQL statements.
	PSIsSQLSupported	Indicates whether the dataset can execute SQL statements.
	PSReset	Resets the dataset so that it is positioned on the first record.
	PSReset	Resets the dataset so that it is positioned on the first record.
	PSSetCommandText	This is PSSetCommandText, a member of class TCustomADODataSet.
	PSSetCommandText	This is the overview for the PSSetCommandText method overload.
	PSSetParams	Assigns the specified parameter values to the dataset.
	PSSetParams	Assigns the specified parameter values to the dataset.
	PSStartTransaction	Starts a transaction that encapsulates all activity until a call to PSEndTransaction.
	PSStartTransaction	Starts a transaction that encapsulates all activity until a call to PSEndTransaction.
	PSUpdateRecord	Applies a single update to the underlying database table or tables.
	PSUpdateRecord	Applies a single update to the underlying database table or tables.
	QueryChanged	This is QueryChanged, a member of class TADOQuery.
	QueryInterface	Returns a reference to a specified interface if the object supports that interface.
	ReadState	Reads the state of the component.
	RecordChangeComplete	This is RecordChangeComplete, a member of class TCustomADODataSet.
	RecordsetChangeComplete	This is RecordsetChangeComplete, a member of class TCustomADODataSet.
	RefreshInternalCalcFields	This is RefreshInternalCalcFields, a member of class TDataSet.
	RefreshParams	This is RefreshParams, a member of class TCustomADODataSet.
	ReleaseLock	This is ReleaseLock, a member of class TCustomADODataSet.
	ResetAggField	This is ResetAggField, a member of class TDataSet.
	RestoreState	This is RestoreState, a member of class TDataSet.
	SetActive	This is SetActive, a member of class TDataSet.
	SetAncestor	Clears or sets csAncestor state in the component's ComponentState property.
	SetBlockReadSize	This is SetBlockReadSize, a member of class TCustomADODataSet.
	SetBlockReadSize	This is SetBlockReadSize, a member of class TDataSet.
	SetBookmarkData	This is SetBookmarkData, a member of class TCustomADODataSet.
	SetBookmarkData	This is SetBookmarkData, a member of class TDataSet.
	SetBookmarkFlag	This is SetBookmarkFlag, a member of class TCustomADODataSet.
	SetBookmarkFlag	This is SetBookmarkFlag, a member of class TDataSet.
	SetBookmarkStr	This is SetBookmarkStr, a member of class TDataSet.
	SetBufListSize	This is SetBufListSize, a member of class TDataSet.
	SetChildOrder	Sets the visual ordering of a child control.
	SetChildOrder	Sets the visual ordering of a child control.
	SetCommandText	This is SetCommandText, a member of class TCustomADODataSet.
	SetConnection	This is SetConnection, a member of class TCustomADODataSet.
	SetConnectionFlag	This is SetConnectionFlag, a member of class TCustomADODataSet.
	SetCurrentRecord	This is SetCurrentRecord, a member of class TDataSet.
	SetDataSetField	This is SetDataSetField, a member of class TDataSet.
	SetDataSource	This is SetDataSource, a member of class TCustomADODataSet.
	SetDefaultFields	This is SetDefaultFields, a member of class TDataSet.
	SetDesigning	Ensures that components inserted at design time have their design-mode flag set.
	SetDesignInstance	Ensures that components inserted at design time have their design-mode flag set.
	SetDetailFilter	This is SetDetailFilter, a member of class TCustomADODataSet.
	SetFieldData	This is the overview for the SetFieldData method overload.
	SetFieldData	This is the overview for the SetFieldData method overload.
	SetFiltered	This is SetFiltered, a member of class TCustomADODataSet.
	SetFiltered	This is SetFiltered, a member of class TDataSet.
	SetFilterOptions	This is SetFilterOptions, a member of class TCustomADODataSet.
	SetFilterOptions	This is SetFilterOptions, a member of class TDataSet.
	SetFilterText	This is SetFilterText, a member of class TCustomADODataSet.
	SetFilterText	This is SetFilterText, a member of class TDataSet.
	SetFound	This is SetFound, a member of class TDataSet.
	SetInline	Sets the csInline bit of the component's ComponentState property
	SetModified	This is SetModified, a member of class TDataSet.
	SetName	Sets the value of the Name property.
	SetName	Sets the value of the Name property.
	SetObjectView	This is SetObjectView, a member of class TDataSet.
	SetOnFilterRecord	This is SetOnFilterRecord, a member of class TDataSet.
	SetParamsFromCursor	This is SetParamsFromCursor, a member of class TCustomADODataSet.
	SetParentComponent	Sets the parent component.
	SetRecNo	This is SetRecNo, a member of class TCustomADODataSet.
	SetRecNo	This is SetRecNo, a member of class TDataSet.
	SetState	This is SetState, a member of class TDataSet.
	SetStateFieldValue	This is SetStateFieldValue, a member of class TDataSet.
	SetTempState	This is SetTempState, a member of class TDataSet.
	SetUniDirectional	This is SetUniDirectional, a member of class TDataSet.
	TempBuffer	This is TempBuffer, a member of class TDataSet.
	UpdateBufferCount	This is UpdateBufferCount, a member of class TDataSet.
	Updated	Clears the csUpdating state in the component's ComponentState property when the component finishes updating.
	UpdateIndexDefs	This is UpdateIndexDefs, a member of class TCustomADODataSet.
	UpdateIndexDefs	This is UpdateIndexDefs, a member of class TDataSet.
	UpdateRecordSetPosition	This is UpdateRecordSetPosition, a member of class TCustomADODataSet.
	UpdateRegistry	Provides the interface for a method that adds type library and version information to the Registry on components that implement COM interfaces.
	Updating	Sets the csUpdating state in the component's ComponentState property.
	ValidateContainer	Determines whether an object can be inserted into a container.
	ValidateInsert	Provides the interface for a method that validates an child component before it is inserted.
	ValidateRename	Ensures that renaming an owned component does not create name conflict.
	WillChangeField	This is WillChangeField, a member of class TCustomADODataSet.
	WillChangeRecord	This is WillChangeRecord, a member of class TCustomADODataSet.
	WillChangeRecordset	This is WillChangeRecordset, a member of class TCustomADODataSet.
	WillMove	This is WillMove, a member of class TCustomADODataSet.
	WriteState	Writes the state of the component.

Protected Properties

	Name	Description
	ActiveRecord	Indicates the index of the active record in the internal cache of records.
	BlobFieldCount	Indicates the number of columns in the dataset that represent Binary large object (BLOB) fields.
	BookmarkSize	Indicates the number of bytes used to represent a bookmark.
	BufferCount	Indicates the number of records in the internal cache.
	Buffers	Provides indexed access to the record buffers in the internal cache.
	CalcBuffer	Points to the record buffer used during an OnCalcFields event.
	CalcFieldsSize	Indicates the number of bytes in a record buffer dedicated to storing calculated fields and lookup fields.
	Command	Provides access to the internal command object that executes commands for the dataset.
	CommandText	Specifies a command to be executed.
	CommandType	Specifies the type of command to execute.
	Constraints	Specifies record-level constraints that must be met when editing the data.
	CurrentRecord	Indicates the index of the current record in the internal cache of record buffers.
	FieldDefs	Points to the list of field definitions for the dataset.
	FieldNoOfs	Specifies the offset needed to convert indexes in the Fields property to field numbers.
	IndexDefs	Contains the definitions of the indexes for the current table.
	IndexFieldNames	Lists the columns to use for a persistent sort of the recordset.
	InternalCalcFields	Indicates whether the dataset includes internally calculated fields.
	MasterDataLink	Manages the relationship between the ADO dataset and a master table.
	MasterFields	Specifies field or fields on which a Master-Detail link is based.
	NestedDataSetClass	Indicates the class type to use when creating nested datasets.
	NestedDataSets	Lists all nested datasets.
	Reserved	For internal use only.
	StoreDefs	Specifies whether field definitions are stored with the ADO dataset.

Public Events

	Name	Description
	AfterCancel	Occurs after an application completes a request to cancel modifications to the active record.
	AfterClose	Occurs after an application closes a dataset.
	AfterDelete	Occurs after an application deletes a record.
	AfterEdit	Occurs after an application starts editing a record.
	AfterInsert	Occurs after an application inserts a new record.
	AfterOpen	Occurs after an application completes opening a dataset and before any data access occurs.
	AfterPost	Occurs after an application writes the active record to the database or change log and returns to browse state.
	AfterRefresh	Occurs after an application refreshes the data in the dataset.
	AfterScroll	Occurs after an application scrolls from one record to another.
	BeforeCancel	Occurs before an application executes a request to cancel changes to the active record.
	BeforeClose	Occurs immediately before the dataset closes.
	BeforeDelete	Occurs before an application attempts to delete the active record.
	BeforeEdit	Occurs before an application enters edit mode for the active record.
	BeforeInsert	Occurs before an application enters insert mode.
	BeforeOpen	Occurs before an application executes a request to open a dataset.
	BeforePost	Occurs before an application posts changes for the active record to the database or change log.
	BeforeRefresh	Occurs immediately before an application refreshes the data in the dataset.
	BeforeScroll	Occurs before an application scrolls from one record to another.
	OnCalcFields	Occurs when an application recalculates calculated fields.
	OnDeleteError	Occurs when an application attempts to delete a record and an exception is raised.
	OnEditError	Occurs when an application attempts to modify or insert a record and an exception is raised.
	OnFilterRecord	Occurs each time a different record in the dataset becomes the active record and filtering is enabled.
	OnNewRecord	Occurs when an application inserts or appends a new dataset record.
	OnPostError	Occurs when an application attempts to modify or insert a record and an exception is raised.

Public Methods

	Name	Description
	_AddRef	Increments the reference count for this interface.
	_Release	Decrements the reference count for this interface.
	ActiveBuffer	Returns a pointer to the buffer for the active record.
	AfterConstruction	Responds after the last constructor has executed.
	Append	Adds a new, empty record to the end of the dataset.
	AppendRecord	Adds a new, populated record to the end of the dataset and posts it.
	Assign	Copies the contents of another, similar object.
	BeforeDestruction	Performs any necessary actions before the first destructor is called.
	BeforeDestruction	Responds before the first destructor executes.
	BookmarkValid	Tests the validity of a specified bookmark.
	BookmarkValid	Indicates the validity of a specified bookmark.
	Cancel	Cancels modifications to the active record if those changes are not yet posted.
	CancelBatch	Cancels a pending batch update.
	CancelUpdates	Cancels pending cached updates.
	CheckBrowseMode	Automatically posts or cancels data changes when the active record changes.
	ClassInfo	Returns a pointer to the runtime type information (RTTI) table for the object type.
	ClassName	Returns a string indicating the type of the object instance (as opposed to the type of the variable passed as an argument).
	ClassNameIs	Determines whether an object is of a specific type.
	ClassParent	Returns the type of the immediate ancestor of a class.
	ClassType	Returns the class reference for the object's class.
	CleanupInstance	Performs finalization on long strings, variants, and interface variables within a class.
	ClearFields	Clears the contents of all fields for the active record.
	Clone	Duplicates another dataset in the calling component
	Close	Closes a dataset.
	CompareBookmarks	Compares two bookmarks.
	CompareBookmarks	Implements a virtual function to compare two bookmarks.
	ControlsDisabled	Indicates whether data-aware controls update their display to reflect changes to the dataset.
	CopyFields	This is CopyFields, a member of class TDataSet.
	Create	Creates an instance of a TADOQuery component.
	CreateBlobStream	Creates a blob stream for a Binary large object (BLOB) field in the dataset.
	CreateBlobStream	Provides the interface for a method that creates a blob stream for a Binary large object (BLOB) field in the dataset.
	CursorPosChanged	Marks the internal cursor position as invalid.
	DefaultHandler	Provides the interface for a method that processes message records.
	Delete	Deletes the active record and positions the dataset on the next record.
	DeleteRecords	Deletes one or more records in the dataset.
	Destroy	Destroys the TADOQuery instance.
	DestroyComponents	Destroys all owned components.
	Destroying	Indicates that the component and its owned components are about to be destroyed.
	DisableControls	Disables data display in data-aware controls associated with the dataset.
	Dispatch	Calls message-handling methods for the object, based on the contents of the Message parameter.
	Edit	Enables editing of data in the dataset.
	EnableControls	Re-enables data display in data-aware controls associated with the dataset.
	Equals	Checks if the current instance and the parameter are equal.
	ExecSQL	Executes the SQL statement for the ADO query.
	ExecuteAction	Executes an action.
	FieldAddress	This is the overview for the FieldAddress method overload.
	FieldByName	Finds a field based on its name.
	FilterOnBookmarks	Filters a data set to just rows with pre-defined bookmarks.
	FindComponent	Indicates whether a given component is owned by the component.
	FindField	Searches for a specified field in the dataset.
	FindFirst	Implements a virtual method for positioning the dataset on the first record, respecting any filters.
	FindLast	Implements a virtual method for positioning the dataset on the last record, respecting any filters.
	FindNext	Implements a virtual method for positioning the dataset on the next record, respecting any filters.
	FindPrior	Implements a virtual method for positioning the dataset on the previous record, respecting any filters.
	First	Moves to the first record in the dataset.
	Free	Destroys an object and frees its associated memory, if necessary.
	FreeBookmark	Frees the resources allocated for a specified bookmark.
	FreeInstance	Deallocates memory allocated by a previous call to the System::TObject::NewInstance method.
	FreeNotification	Ensures that AComponent is notified that the component is going to be destroyed.
	FreeOnRelease	Frees the interface reference for components that were created from COM classes.
	GetBlobFieldData	Retrieves the current value of a field into a buffer.
	GetBlobFieldData	Reads BLOB data into a buffer.
	GetBookmark	Allocates a bookmark for the active record in the dataset.
	GetComponent	Returns a reference to the component associated by the implementing class.
	GetCurrentRecord	Implements a virtual function to retrieve the current record in a buffer.
	GetDetailDataSets	Fills a list with a dataset for every detail dataset that is not the value of a nested dataset field.
	GetDetailLinkFields	Lists the field components that link this dataset as a detail of a master dataset.
	GetDetailLinkFields	Introduces a method to list the field components that link this dataset as a detail of a master dataset.
	GetEnumerator	Returns a TComponent enumerator.
	GetFieldData	This is the overview for the GetFieldData method overload.
	GetFieldData	This is the overview for the GetFieldData method overload.
	GetFieldList	Retrieves a specified set of field objects into a list.
	GetFieldNames	This is the overview for the GetFieldNames method overload.
	GetHashCode	Returns an integer containing the hash code.
	GetInterface	Retrieves a specified interface.
	GetInterfaceEntry	Returns the entry for a specific interface implemented in a class.
	GetInterfaceTable	Returns a pointer to a structure containing all of the interfaces implemented by a given class.
	GetNamePath	Returns a string used by the Object Inspector.
	GetNamePath	Returns the name of the object as it appears in the Object Inspector.
	GetParentComponent	Returns the containing Component.
	GotoBookmark	Implements a virtual method to position the dataset on the record to which a specified bookmark points.
	HasParent	Verifies whether the component has a parent.
	InheritsFrom	Determines the relationship of two object types.
	InitInstance	Initializes a newly allocated object instance to all zeros and initializes the instance's virtual method table pointer.
	Insert	Inserts a new, empty record in the dataset.
	InsertComponent	Establishes the component as the owner of a specified component.
	InsertRecord	Inserts a new, populated record to the dataset and posts it.
	InstanceSize	Returns the size in bytes of each instance of the object type.
	IsEmpty	Indicates whether the dataset contains no records.
	IsImplementorOf	Indicates whether the component implements a specified interface.
	IsLinkedTo	Indicates whether a dataset is linked to a specified data source.
	IsSequenced	Indicates whether the underlying database table uses record numbers to indicate the order of records.
	IsSequenced	Indicates whether the underlying database table uses record numbers to indicate the order of records.
	Last	Moves to the last record in the dataset.
	LoadFromFile	Loads a recordset from a file.
	Locate	Searches the dataset for a specified record and makes that record the current record.
	Locate	Implements a virtual method for searching a dataset for a specified record and making it the active record.
	Lookup	Retrieves field values from a row that matches specified search values.
	Lookup	Implements a virtual method to retrieve field values from a record that matches specified search values.
	MethodAddress	This is the overview for the MethodAddress method overload.
	MethodName	Returns the name of a class method by address.
	MoveBy	Moves to another record relative to the active record in the dataset.
	NewInstance	Allocates memory for an instance of an object type and returns a pointer to that new instance.
	Next	Moves to the next record in the dataset.
	NextRecordset	Provides access to a secondary recordset.
	Open	Opens the dataset.
	Post	Implements a virtual method to write a modified record to the database or change log.
	Prior	Moves to the previous record in the dataset.
	PSEndTransaction	Ends a transaction that was started by a call to PSStartTransaction.
	PSExecute	Executes the SQL command associated with the dataset.
	PSExecuteStatement	Executes a specified SQL command.
	PSGetAttributes	Returns information that is stored in data packets as Name/Value pairs.
	PSGetCommandText	Gets the SQL command to be executed by PSExecute.
	PSGetCommandType	Gets the command type to be executed by PSExecute.
	PSGetDefaultOrder	Returns the definition of an index that imposes the default order on the data included in data packets.
	PSGetIndexDefs	Returns the definitions of all specified indexes defined for the dataset.
	PSGetKeyFields	Returns the names of all fields required to uniquely identify records in the data packet.
	PSGetParams	Returns the current parameter values of the dataset.
	PSGetQuoteChar	Returns the character or characters to use in generated SQL statements to enclose quoted strings.
	PSGetTableName	Returns the name of the dataset table that appears in generated SQL statements.
	PSGetUpdateException	Generates an EUpdateError object based on another exception object.
	PSInTransaction	Indicates whether actions against the dataset occur in the context of a transaction.
	PSIsSQLBased	Indicates whether the dataset includes native SQL support.
	PSIsSQLSupported	Indicates whether the dataset can execute SQL statements.
	PSReset	Resets the dataset so that it is positioned on the first record.
	PSSetCommandText	Assigns a specified SQL command to be executed by PSExecute.
	PSSetParams	Assigns the specified parameter values to the dataset.
	PSStartTransaction	Starts a transaction that encapsulates all activity until a call to PSEndTransaction.
	PSUpdateRecord	Applies a single update to the underlying database table or tables.
	QueryInterface	Returns a reference to a specified interface if the object supports that interface.
	ReferenceInterface	Establishes or removes internal links that cause this component to be notified when the implementer of a specified interface is destroyed.
	Refresh	Re-fetches data from the database to update a dataset's view of data.
	RemoveComponent	Removes a specified component specified from the component's Components list.
	RemoveFreeNotification	Disables destruction notification that was enabled by FreeNotification
	Requery	Refreshes the recordset.
	Resync	Re-fetches the active record and the records that precede and follow it.
	SafeCallException	Handles exceptions in methods declared using the safecall calling convention.
	SafeCallException	Handles exceptions in methods declared using the safecall calling convention.
	SaveToFile	Saves a recordset to a file.
	Seek	Searches for a record using the current index.
	SetFields	Sets the values for all fields in a record
	SetSubComponent	Identifies whether the component is a subcomponent.
	Supports	Indicates whether a dataset supports certain types of operations.
	ToString	Returns a string containing the class name.
	Translate	Implements a virtual procedure to copy a data string from a source to a destination, optionally performing character translation during the copy.
	UnitName	Returns a string containing the unit name.
	UpdateAction	Updates the state of an action.
	UpdateBatch	Writes pending batch updates to disk.
	UpdateCursorPos	Positions the cursor on the active record.
	UpdateRecord	Ensures that data-aware controls and detail datasets reflect record updates.
	UpdateStatus	Indicates the update status of the current record.
	UpdateStatus	Reports the update status for the active record.

Public Properties

	Name	Description
	Active	Specifies whether or not a dataset is open.
	AggFields	Contains any aggregate fields.
	AutoCalcFields	Determines when the OnCalcFields event is triggered and when lookup field values are calculated.
	BlockReadSize	Determines how many record buffers are read in each block.
	Bof	Indicates whether the first record in the dataset is active.
	Bookmark	Specifies the current bookmark in the dataset.
	CanModify	Indicates whether the dataset permits write access to data.
	ComObject	Specifies the interface reference implemented by the component.
	ComponentCount	Indicates the number of components owned by the component.
	ComponentIndex	Indicates the position of the component in its owner's Components property array.
	Components	Lists all components owned by the component.
	ComponentState	Describes the current state of the component, indicating when a component needs to avoid certain actions.
	ComponentStyle	Governs the behavior of the component.
	DataSetField	Indicates the persistent TDataSetField object that owns a nested dataset.
	DefaultFields	Indicates whether a dataset's underlying field components are generated dynamically when the dataset is opened.
	Designer	Returns a pointer to the DataSet designer for the dataset.
	DesignerData	Stores custom data.
	DesignInfo	Contains information used by the Form designer.
	Eof	Indicates whether a dataset is positioned at the last record.
	FieldCount	Indicates the number of field components associated with the dataset.
	FieldDefList	Points to the list of field definitions for the dataset.
	FieldDefs	Points to the list of field definitions for the dataset.
	FieldList	Lists the field components of a dataset.
	Fields	Lists all non-aggregate field components of the dataset.
	FieldValues	Provides access to the values for all fields in the active record for the dataset
	Filter	Specifies the text of the current filter for a dataset.
	Filtered	Specifies whether or not filtering is active for a dataset.
	FilterGroup	Filters a recordset based on row update status.
	FilterOptions	Specifies whether or not filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records.
	Found	Indicates whether or not moving to a different record is successful.
	IndexFieldCount	Indicates the number of fields that comprise the current key.
	IndexFields	Retrieves or sets a field for an index.
	IndexName	Specifies the currently active index.
	IsUniDirectional	Indicates whether the dataset is unidirectional.
	Modified	Indicates whether the active record is modified.
	ObjectView	Specifies whether fields are stored hierarchically or flattened out in the Fields property.
	Owner	Indicates the component that is responsible for streaming and freeing this component.
	Properties	Properties is the implementation of the Properties Collection object.
	RecNo	Indicates the active record in the dataset.
	RecordCount	Indicates the total number of records associated with the dataset.
	Recordset	Provides direct access to the ADO Recordset object.
	RecordsetState	Indicates the current state of the ADO dataset component.
	RecordSize	Indicates the size of a record in the dataset.
	RecordStatus	Indicates the status of the current row.
	RowsAffected	Returns the number of rows operated upon by the latest query execution.
	Sort	Specifies the sort order of the recordset.
	SparseArrays	Determines whether a unique TField object is created for each element of an array field.
	State	Indicates the current operating mode of the dataset.
	VCLComObject	Represents information used internally by components that support COM.

Published Events

	Name	Description
	AfterCancel	Occurs after an application completes a request to cancel modifications to the active record.
	AfterClose	Occurs after an application closes a dataset.
	AfterDelete	Occurs after an application deletes a record.
	AfterEdit	Occurs after an application starts editing a record.
	AfterInsert	Occurs after an application inserts a new record.
	AfterOpen	Occurs after an application completes opening a dataset and before any data access occurs.
	AfterPost	Occurs after an application writes the active record to the database or change log and returns to browse state.
	AfterRefresh	Occurs after an application refreshes the data in the dataset.
	AfterScroll	Occurs after an application scrolls from one record to another.
	BeforeCancel	Occurs before an application executes a request to cancel changes to the active record.
	BeforeClose	Occurs immediately before the dataset closes.
	BeforeDelete	Occurs before an application attempts to delete the active record.
	BeforeEdit	Occurs before an application enters edit mode for the active record.
	BeforeInsert	Occurs before an application enters insert mode.
	BeforeOpen	Occurs before an application executes a request to open a dataset.
	BeforePost	Occurs before an application posts changes for the active record to the database or change log.
	BeforeRefresh	Occurs immediately before an application refreshes the data in the dataset.
	BeforeScroll	Occurs before an application scrolls from one record to another.
	OnCalcFields	Occurs when an application recalculates calculated fields.
	OnDeleteError	Occurs when an application attempts to delete a record and an exception is raised.
	OnEditError	Occurs when an application attempts to modify or insert a record and an exception is raised.
	OnEndOfRecordset	Occurs when moving a recordset's row pointer past the last row.
	OnFetchComplete	Occurs after records have been retrieved into the recordset.
	OnFetchProgress	Occurs periodically during an asynchronous data retrieval operation.
	OnFieldChangeComplete	Occurs after a field has changed.
	OnFilterRecord	Occurs each time a different record in the dataset becomes the active record and filtering is enabled.
	OnMoveComplete	Occurs after the row pointer in a recordset has moved.
	OnNewRecord	Occurs when an application inserts or appends a new dataset record.
	OnPostError	Occurs when an application attempts to modify or insert a record and an exception is raised.
	OnRecordChangeComplete	Occurs after one or more records in the recordset change.
	OnRecordsetChangeComplete	Occurs after the recordset has changed.
	OnRecordsetCreate	Occurs when the recordset has been initialized and is ready to use.
	OnWillChangeField	Occurs before a field is changed.
	OnWillChangeRecord	Occurs before a record in the recordset is changed.
	OnWillChangeRecordset	Occurs before the recordset has changed.
	OnWillMove	Occurs before the row pointer in a recordset is moved.

Published Properties

	Name	Description
	Active	Specifies whether or not a dataset is open.
	AutoCalcFields	Determines when the OnCalcFields event is triggered and when lookup field values are calculated.
	CacheSize	Specifies the size of the cache for the dataset.
	CommandTimeout	Specifies amount of time to attempt execution of a command.
	Connection	Specifies the ADO connection component to use.
	ConnectionString	Specifies the connection information for the data store.
	CursorLocation	Specifies whether the cursor for the connection is client-side or server-side.
	CursorType	Specifies type of cursor an ADO dataset uses.
	DataSource	Specifies the data source component from which to extract current field values to use in same-name parameters in the ADO query's SQL statement.
	EnableBCD	Specifies whether to treat numeric fields as floating-point or BCD.
	ExecuteOptions	Specifies the characteristics of a command execution.
	Filter	Specifies the text of the current filter for a recordset.
	Filtered	Specifies whether or not filtering is active for a dataset.
	LockType	Specifies the lock type to use when opening a dataset.
	MarshalOptions	Specifies which records are marshaled back to the server.
	MaxRecords	Specifies how many rows to return in a result set.
	Name	Specifies the name of the component as referenced in code.
	ParamCheck	Specifies whether the parameter list for an ADO dataset component is regenerated if the SQL changes at runtime.
	Parameters	Contains the collection of parameters for an SQL statement.
	Prepared	Specifies whether the command is prepared before execution.
	SQL	Contains the text of the SQL statement to execute for the ADO query.
	Tag	Stores an integer value as part of a component.

What do you think about this topic? Send feedback!