Data.Win.ADODB.TADOQuery Methods

• Up to Parent: TADOQuery

InheritedProtected

_AddRef	protected	Called when an application uses a component interface.
_Release	protected	Called when an application releases a component interface.
ActivateBuffers	protected	Activates the buffers for the active record.
ActivateTextFilter	protected
ActiveBuffer	public	Returns a pointer to the buffer for the active record.
AfterConstruction	public	Responds after the last constructor has executed.
AllocRecordBuffer	protected
Append	public	Adds a new, empty record to the end of the dataset.
AppendRecord	public	Adds a new, populated record to the end of the dataset and posts it.
AreParamsMasterDependent	protected
Assign	public	Copies the contents of another similar object.
AssignTo	protected	Copies the properties of an object to a destination object.
AsyncSchedule	protected	Schedules asynch method calls.
BeforeDestruction	public	Performs any necessary actions before the first destructor is called.
BeginInvoke	public	Performs an asynchronous call to the method specified by either AProc or AFunc.
BindFields	protected	Binds the TField components to the physical fields.
BlockReadNext	protected	Moves to the record from the next block and reads it.
BookmarkAvailable	protected	Verifies whether there is a bookmark available.
BookmarkValid	public	Tests the validity of a specified bookmark.
CalculateFields (deprecated)	protected	Calculates the lookup fields.
Cancel	public	Cancels modifications to the active record if those changes are not yet posted.
CancelBatch	public	Cancels a pending batch update.
CancelUpdates	public	Cancels pending cached updates.
CanObserve	protected	Checks if a component can be observed by a particular observer.
ChangeName	protected	Sets the private, internal storage for the Name property to the string passed in NewName.
CheckActive	protected
CheckBiDirectional	protected	Checks whether the dataset is bidirectional.
CheckBrowseMode	public	Automatically posts or cancels data changes when the active record changes.
CheckDisposed	protected	This method is deprecated.
CheckFieldCompatibility	protected
CheckInactive	protected	Checks whether the dataset is inactive.
ClassInfo	public	Returns a pointer to the run-time type information (RTTI) table for the object type.
ClassName	public	Returns a string indicating the type of the object instance (as opposed to the type of the variable passed as an argument).
ClassNameIs	public	Determines whether an object is of a specific type.
ClassParent	public	Returns the type of the immediate ancestor of a class.
ClassType	public	Returns the class reference for the object's class.
CleanupInstance	public	Performs finalization on long strings, variants, and interface variables within a class.
ClearBuffers	protected	Clears the buffers for the active record.
ClearCalcFields	protected
ClearFields	public	Clears the contents of all fields for the active record.
Clone	public	Duplicates another dataset in the calling component
Close	public	Closes a dataset.
CloseBlob	protected	Closes a binary large object field.
CloseCursor	protected	Closes the dataset cursor.
CompareBookmarks	public	Compares two bookmarks.
ConnectionPoint	protected
ControlsDisabled	public	Indicates whether data-aware controls update their display to reflect changes to the dataset.
CopyFields	public	CopyFields copies the field definition structure of another dataset.
Create	public	Creates an instance of a TADOQuery component.
CreateBlobStream	public	Creates a blob stream for a Binary large object (BLOB) field in the dataset.
CreateFields	protected	Creates the automatic fields.
CreateNestedDataSet	protected	Creates a nested dataset.
CursorPosChanged	public	Marks the internal cursor position as invalid.
DataConvert (deprecated)	protected	Converts the data depending on the field type.
DataEvent	protected
DeactivateFilters	protected
DefaultFields (deprecated)	public	Indicates whether a dataset's underlying field components are generated dynamically when the dataset is opened.
DefaultHandler	public	Provides the interface for a method that processes message records.
DefChanged	protected
DefineProperties	protected
Delete	public	Deletes the active record and positions the dataset on the next record.
DeleteRecords	public	Deletes one or more records in the dataset.
Destroy	public	Destroys the TADOQuery instance.
DestroyComponents	public	Destroys all owned components.
DestroyFields	protected	Destroys the dataset automatic fields.
Destroying	public	Indicates that the component and its owned components are about to be destroyed.
DestroyLookupCursor	protected
DisableControls	public	Disables data display in data-aware controls associated with the dataset.
Dispatch	public	Calls message-handling methods for the object, based on the contents of the Message parameter.
DisposeOf (deprecated)	public	DisposeOf forces the execution of the destructor code in an object.
DoAfterCancel	protected	AfterCancel event dispatcher.
DoAfterClose	protected	AfterClose event dispatcher.
DoAfterDelete	protected	AfterDelete event dispatcher.
DoAfterEdit	protected	AfterEdit event dispatcher.
DoAfterInsert	protected	AfterInsert event dispatcher.
DoAfterOpen	protected	AfterOpen event dispatcher.
DoAfterPost	protected	AfterPost event dispatcher.
DoAfterRefresh	protected	AfterRefresh event dispatcher.
DoAfterScroll	protected	AfterScroll event dispatcher.
DoBeforeCancel	protected	BeforeCancel event dispatcher.
DoBeforeClose	protected	BeforeClose event dispatcher.
DoBeforeDelete	protected	BeforeDelete event dispatcher.
DoBeforeEdit	protected	BeforeEdit event dispatcher.
DoBeforeInsert	protected	BeforeInsert event dispatcher.
DoBeforeOpen	protected	BeforeOpen event dispatcher.
DoBeforePost	protected	BeforePost event dispatcher.
DoBeforeRefresh	protected	BeforeRefresh event dispatcher.
DoBeforeScroll	protected	BeforeScroll event dispatcher.
DoOnCalcFields	protected	OnCalcFields event dispatcher.
DoOnNewRecord	protected
Edit	public	Enables editing of data in the dataset.
EnableControls	public	Re-enables data display in data-aware controls associated with the dataset.
EnableEvents	protected
EndFunctionInvoke	public	Blocks the caller until the specified ASyncResult completes.
EndInvoke	public	Blocks the caller until the specified ASyncResult completes.
EndOfRecordset	protected
Equals	public	Checks whether the current instance and the Obj parameter are equal.
ExecSQL	public	Executes the SQL statement for the ADO query.
ExecuteAction	public	Executes an action.
FetchComplete	protected
FetchProgress	protected
FieldAddress	public	Returns the address of a published object field.
FieldByName	public	Finds a field based on its name.
FieldByNumber	protected	Finds a field based on the ordinal position of its column in the underlying table or query.
FieldChangeComplete	protected
FilterOnBookmarks	public	Filters a dataset to just rows with pre-defined bookmarks.
FindComponent	public	Indicates whether a given component is owned by the component.
FindField	public	Searches for a specified field in the dataset.
FindFirst	public	Implements a virtual method for positioning the dataset on the first record, respecting any filters.
FindLast	public	Implements a virtual method for positioning the dataset on the last record, respecting any filters.
FindNext	public	Implements a virtual method for positioning the dataset on the next record, respecting any filters.
FindPrior	public	Implements a virtual method for positioning the dataset on the previous record, respecting any filters.
FindRecord	protected
First	public	Moves to the first record in the dataset.
Free	public	Destroys an object and frees its associated memory, if necessary.
FreeBookmark	public	Frees the resources allocated for a specified bookmark (somewhat obsolete).
FreeFieldBuffers	protected	Frees the field buffers.
FreeInstance	public	Deallocates memory allocated by a previous call to the NewInstance method.
FreeNotification	public	Ensures that AComponent is notified that the component is going to be destroyed.
FreeOnRelease	public	Frees the interface reference for components that were created from COM classes.
FreeRecordBuffer	protected
GetActiveRecBuf	protected
GetAggFieldsClass	protected	Returns the metaclass for the aggregate fields.
GetAggRecordCount	protected	Returns the number of aggregate fields.
GetAggregateValue	protected	Returns the value for an aggregate field.
GetBlobFieldData	public	Retrieves the current value of a field into a buffer.
GetBookmark	public	Allocates a bookmark for the active record in the dataset.
GetBookmarkData (deprecated)	protected
GetBookmarkFlag	protected
GetBookmarkStr (deprecated)	protected	Gets a bookmark represented as a string.
GetCalcFields (deprecated)	protected	Computes the lookup and calculated fields and updates the status.
GetCalcFieldTypes	protected
GetCanModify	protected
GetCanRefresh	protected
GetCheckConstraintsClass	protected	Returns the metaclass for TCheckConstraints.
GetChildOwner	protected	Returns the owner of a child component being read from a stream.
GetChildParent	protected	Returns the parent or, if there is no parent, returns the owner of a child component being read from a stream.
GetChildren	protected	Enumerates all the owned datasets that are also owned by the specified TComponent.
GetClonedDataSet	public
GetCommandText	protected
GetCurrentRecord (deprecated)	public	Implements a virtual function to retrieve the current record in a buffer.
GetDataSource	protected
GetDeltaStreams	protected	Retrieves a list of streams representing the differences (deltas) between the current state of a component and a previously saved state.
GetDetailDataSets (deprecated)	public	Fills a list with a dataset for every detail dataset that is not the value of a nested dataset field.
GetDetailLinkFields (deprecated)	public	Lists the field components that link this dataset as a detail of a master dataset.
GetDisposed	protected	Getter for the Disposed property.
GetEnumerator	public	Returns a TComponent enumerator.
GetFieldClass	protected	Returns the metaclass for a field class.
GetFieldData (deprecated)	public	Retrieves the current value of a field into a buffer.
GetFieldDefListClass	protected	Returns the metaclass for a field definition list class.
GetFieldDefsClass	protected	Returns the metaclass of the TFieldDefs class.
GetFieldFullName	protected	Returns the full name of the field.
GetFieldList (deprecated)	public	Retrieves a specified set of field objects into a list.
GetFieldListClass	protected	Returns the metaclass for a field list class.
GetFieldNames	public	Retrieves a list of names for all fields in a dataset.
GetFieldsClass	protected	Returns the TFields descendant metaclass.
GetHashCode	public	Returns an integer containing the hash code.
GetIDsOfNames	protected	Maps a single member and an optional set of argument names to a corresponding set of integer dispatch identifiers (dispIDs).
GetIndexDefs	protected	Returns the definitions of all specified indexes defined for the dataset.
GetIndexDefsClass	protected	Returns the metaclass for an index definition list.
GetInterface	public	Retrieves a specified interface.
GetInterfaceEntry	public	Returns the entry for a specific interface implemented in a class.
GetInterfaceTable	public	Returns a pointer to a structure containing all of the interfaces implemented by a given class.
GetIsIndexField	protected	Checks whether the given field is an index field.
GetLookupListClass	protected	Returns the metaclass for a lookup field list class.
GetModifiedBlobCached	protected
GetNamePath	public	Returns a string used by the Object Inspector.
GetNextRecord	protected	Moves to the next record.
GetNextRecords	protected	Moves to the last record of the dataset.
GetObservers	protected	Getter of Observers.
GetOwner	protected	Returns the owner of a component.
GetParamsClass	protected	Returns the metaclass for a list of field parameters.
GetParentComponent	public	Returns the containing component.
GetPriorRecord	protected	Moves to the prior record.
GetPriorRecords	protected	Moves to the first record of the dataset.
GetRecNo	protected
GetRecord	protected
GetRecordCount	protected
GetRecordSize	protected
GetStateFieldValue	protected
GetStoredFieldKinds	protected
GetTypeInfo	protected	Retrieves the type information for an object.
GetTypeInfoCount	protected	Returns the number of type information interfaces that an object provides (either 0 or 1).
GotoBookmark	public	Implements a virtual method to position the dataset on the record to which a specified bookmark points.
HasParent	public	Verifies whether the component has a parent.
InheritsFrom	public	Determines the relationship of two object types.
InitFieldDefs	protected	Initializes the field definitions.
InitFieldDefsFromFields	protected	Initializes the field definitions from persistent fields.
InitializeMasterFields	protected
InitInstance	public	Initializes a newly allocated object instance to all zeros and initializes the instance's virtual method table pointer.
InitOleDBAccess	protected
InitRecord (deprecated)	protected	Initializes a record.
Insert	public	Inserts a new, empty record in the dataset.
InsertComponent	public	Establishes the component as the owner of a specified component.
InsertRecord	public	Inserts a new, populated record to the dataset and posts it.
InstanceSize	public	Returns the size in bytes of each instance of the object type.
InternalAddRecord (deprecated)	protected
InternalCancel	protected
InternalClose	protected
InternalDelete	protected
InternalEdit	protected
InternalFirst	protected
InternalGetRecord	protected
InternalGotoBookmark (deprecated)	protected
InternalHandleException	protected
InternalInitFieldDefs	protected
InternalInitRecord	protected
InternalInsert	protected
InternalLast	protected
InternalOpen	protected
InternalPost	protected
InternalRefresh	protected
InternalRequery	protected
InternalSetSort	protected
InternalSetToRecord	protected
Invoke	protected	Provides access to Automation properties and methods when the component wraps an Automation object.
IsCursorOpen	protected
IsEmpty	public	Indicates whether the dataset contains no records.
IsImplementorOf	public	Indicates whether the component implements a specified interface.
IsLinkedTo	public	Indicates whether a dataset is linked to a specified data source.
IsSequenced	public	Indicates whether the underlying database table uses record numbers to indicate the order of records.
Last	public	Moves to the last record in the dataset.
Loaded	protected
LoadFromFile	public	Loads a recordset from a file.
Locate	public	Searches the dataset for a specified record and makes that record the current record.
LocateRecord	protected
Lookup	public	Retrieves field values from a row that matches specified search values.
MasterChanged	protected
MasterDisabled	protected
MethodAddress	public	Returns the address of a class method by name.
MethodName	public	Returns the name of a class method by address.
MoveBy	public	Moves to another record relative to the active record in the dataset.
MoveComplete	protected
NewInstance	public	Allocates memory for an instance of an object type and returns a pointer to that new instance.
Next	public	Moves to the next record in the dataset.
NextRecordset	public	Provides access to a secondary recordset.
Notification	protected	Forwards notification messages to all owned components.
ObserverAdded	protected	Allows the component to handle the addition of an observer.
Open	public	Opens the dataset.
OpenCursor	protected
OpenCursorComplete	protected	Opens the database cursor and triggers an AfterOpen event.
OpenParentDataSet	protected	Opens the parent dataset.
operator []	public
operator ()	public
Post	public	Implements a virtual method to write a modified record to the database or change log.
PrepareCursor	protected
Prior	public	Moves to the previous record in the dataset.
PSEndTransaction	protected
PSExecute	protected
PSExecuteStatement (deprecated)	protected
PSGetAttributes	protected
PSGetCommandText	protected
PSGetCommandType	protected
PSGetDefaultOrder	protected
PSGetIndexDefs	protected
PSGetKeyFields	protected
PSGetParams	protected
PSGetQuoteChar	protected
PSGetTableName	protected
PSGetUpdateException	protected
PSInTransaction	protected
PSIsSQLBased	protected
PSIsSQLSupported	protected
PSReset	protected
PSSetCommandText	protected
PSSetParams	protected
PSStartTransaction	protected
PSUpdateRecord	protected
QualifiedClassName	public	Returns the qualified name of the class.
QueryChanged	protected
QueryInterface	protected	Returns a reference to a specified interface if the current component supports that interface.
ReadState	protected	Reads the state of the component.
RecordChangeComplete	protected
RecordsetChangeComplete	protected
ReferenceInterface	public	Establishes or removes internal links that cause this component to be notified when the implementer of a specified interface is destroyed.
Refresh	public	Re-fetches data from the database to update a dataset's view of data.
RefreshInternalCalcFields (deprecated)	protected	Refreshes the calculated fields.
RefreshParams	protected
ReleaseLock	protected
RemoveComponent	public	Removes a specified component specified from the component's Components list.
RemoveFreeNotification	public	Disables the destruction notification that was enabled by FreeNotification.
RemoveFreeNotifications	protected	Notifies all owned components of the owner component's imminent destruction.
Requery	public	Refreshes the recordset.
ResetAggField	protected	Resets the aggregate field.
RestoreState	protected	Restores the operating mode of the dataset to the given value.
Resync	public	Re-fetches the active record and the records that precede and follow it.
SafeCallException	public	Handles exceptions in methods declared using the safecall calling convention.
SaveToFile	public	Saves a recordset to a file.
Seek	public	Searches for a record using the current index.
SetActive	protected	Changes the dataset's state to active.
SetAncestor	protected	Clears or sets csAncestor state in the component's ComponentState property.
SetBlockReadSize	protected
SetBof	protected
SetBookmarkData (deprecated)	protected
SetBookmarkFlag	protected
SetBookmarkStr (deprecated)	protected	Sets a bookmark represented as a string.
SetBufListSize	protected	Sets the size of the buffer list.
SetChildOrder	protected	Sets the visual ordering of a child dataset.
SetCommandText	protected
SetConnection	protected
SetConnectionFlag	protected	Specifies whether an action is performed on the database.
SetCurrentRecord	protected	Moves to the record given by the index.
SetDataSetField	protected	Sets the persistent TDataSetField object that owns a nested dataset.
SetDataSource	protected
SetDefaultFields (deprecated)	protected	Specifies whether a dataset's underlying field components are generated dynamically when the dataset is opened.
SetDesigning	protected	Ensures that components inserted at design time have their design-mode flag set.
SetDesignInstance	protected	Ensures that components inserted at design time have their design-mode flag set.
SetDetailFilter	protected
SetEof	protected
SetFieldData (deprecated)	protected
SetFieldDefProps	protected	Sets the properties of the specified FieldDef from the Field parameter.
SetFieldProps	protected	Sets the properties of the specified Field from the FieldDef parameter.
SetFields	public	Sets the values for all fields in a record
SetFiltered	protected
SetFilterOptions	protected
SetFilterText	protected
SetFound	protected	Sets a "found" flag.
SetInline	protected	Sets the csInline bit of the component's ComponentState property.
SetModified	protected	Used internally to set the Modified property.
SetName	protected
SetObjectView	protected	Sets the ObjectView property.
SetOnFilterRecord	protected	OnFilterRecord event setter method.
SetParamsFromCursor	protected
SetParentComponent	protected	Sets the parent component.
SetRecNo	protected
SetState	protected	Sets the dataset's state.
SetStateFieldValue	protected	Sets a Field to a Value.
SetSubComponent	public	Identifies whether the component is a subcomponent.
SetTempState	protected	Restores the operating mode of the dataset to the given value.
SetUniDirectional	protected	Sets the dataset type: unidirectional or not.
SetValidatingField	protected
Supports	public	Indicates whether a dataset supports certain types of operations.
TempBuffer	protected	Returns a temporary buffer.
ToString	public	Returns a string containing the class name.
Translate	public	Implements a virtual procedure to copy a data string from a source to a destination, optionally performing character translation during the copy.
UnitName	public	Returns the name of the unit where the class is defined.
UnitScope	public	Returns the class's unit scope.
UpdateAction	public	Updates the state of an action.
UpdateBatch	public	Writes pending batch updates to disk.
UpdateBufferCount	protected	Updates the buffer count.
UpdateCursorPos	public	Positions the cursor on the active record.
Updated	protected	Clears the csUpdating state in the component's ComponentState property when the component finishes updating.
UpdateIndexDefs	protected
UpdateRecord	public	Ensures that data-aware controls and detail datasets reflect record updates.
UpdateRecordSetPosition	protected
UpdateRegistry	protected	Provides the interface for a method that adds type library and version information to the Registry on components that implement COM interfaces.
UpdateStatus	public	Indicates the update status of the current record.
Updating	protected	Sets the csUpdating state in the component's ComponentState property.
ValidateContainer	protected	Determines whether an object can be inserted into a container.
ValidateInsert	protected	Provides the interface for a method that validates a child component before it is inserted.
ValidateRename	protected	Ensures that renaming an owned component does not create a name conflict.
WillChangeField	protected
WillChangeRecord	protected
WillChangeRecordset	protected
WillMove	protected
WriteState	protected	Writes the state of the component.