Data.Win.ADODB.TADOQuery Methods
From RAD Studio API Documentation
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.
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.
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.
CancelBatch public Cancels a pending batch update.
CancelUpdates public Cancels pending cached updates.
CanObserve protected
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
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
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.
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
DeleteRecords public Deletes one or more records in the dataset.
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.
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
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.
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
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.
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.
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
OpenCursor protected
OpenCursorComplete protected Opens the database cursor and triggers an AfterOpen event.
OpenParentDataSet protected Opens the parent dataset.
operator [] public
operator () public
PaletteCreated protected Responds when the component is created from the component palette.
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
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
SetFieldData (deprecated) protected
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.
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.
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.