DAC for MySQL

TmySQLMacroQuery.Methods

Previous Next

Please see TmySQLMacroQuery methods short descriptions below:

Derived from TDataSet

ActiveBuffer

Returns a pointer to the buffer for the active record.

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 to the database.

CheckBrowseMode

Automatically posts or cancels data changes when an application changes which record in the dataset is the active record.

ClearFields

Clears the contents of all fields for the active record.

Close

Closes a dataset.

ControlsDisabled

Indicates whether data-aware controls do not update their display to reflect changes to the dataset.

CursorPosChanged

Marks the internal cursor position as invalid.

Delete

Deletes the active record and positions the cursor on the next record.

DisableControls

Disables data display in data-aware controls associated with the dataset.

Edit

Enables editing of data in the dataset.

EnableControls

Re-enables data display in data-aware controls associated with the dataset.

FieldByName

Finds a field based on its name.

FindField

Searches for a specified field in the dataset.

FindFirst

Implements a virtual method for positioning the cursor on the first record in a filtered dataset.

FindLast

Implements a virtual method for positioning the cursor on the last record in a filtered dataset.

FindNext

Implements a virtual method for positioning the cursor on the next record in a filtered dataset.

FindPrior

Implements a virtual method for positioning the cursor on the previous record in a filtered dataset.

First

Positions the cursor on the first record in the dataset.

FreeBookmark

Frees the resources allocated for a specified bookmark.

GetBookmark

Allocates a bookmark for the current cursor position in the dataset.

GetDetailDataSets

Fills a list with a dataset for every detail dataset that is not the value of a nested dataset field.

GetFieldList

Retrieves a specified set of field objects into a list.

GetFieldNames

Retrieves a list of names for all fields in a dataset.

GotoBookmark

Implements a virtual method to position the cursor on the record pointed to by a specified bookmark.

Insert

Inserts a new, empty record in the dataset.

InsertRecord

Inserts a new, populated record to the dataset and posts it to the database.

IsEmpty

Indicates whether the dataset contains no records.

IsLinkedTo

Indicates whether a dataset is linked to a specified data source.

Last

Positions the cursor on the last record in the dataset.

MoveBy

Positions the cursor on a record relative to the active record in the dataset.

Next

Positions the cursor on the next record in the dataset.

Open

Opens the dataset.

Prior

Positions the cursor on the previous record in the dataset.

Refresh

Refetches data from the database to update a dataset's view of data.

Resync

Refetches the active record and the records that precede and follow it.

SetFields

Sets the values for all fields in a record.

UpdateCursorPos

Positions the cursor on the active record.

UpdateRecord

Ensures that data-aware controls and detail datasets reflect record updates.

Derived from TMySQLDataSet

ApplyUpdates

Writes a dataset's pending cached updates to the database.

BookmarkValid

Tests the validity of a specified bookmark.

Cancel

Cancels modifications to the current record if those changes are not yet posted.

CancelUpdates

Clears all pending cached updates from the cache and restores the dataset its prior state.

CheckOpen

Checks the result of a call to the MySQL.

CloseDatabase

Closes a database connection associated with the database.

CommitUpdates

Clears the cached updates buffer.

CompareBookmarks

Indicates the relationship between two bookmarks.

FetchAll

Retrieves all records from the current cursor position to the end of the file and stores them locally.

FlushBuffers

Posts all changes that have been written to the record buffer.

GetBlobFieldData

Reads BLOB data into a buffer.

GetCurrentRecord

Retrieves the current record into a buffer.

GetFieldData

Retrieves the current value of a field into a buffer.

GetIndexInfo

Retrieves information about the current index into the index data fields of the dataset.

GetLastInsertID

Returns the ID generated for an AUTO_INCREMENT column by the previous query.

Locate

Searches the dataset for a specified record and makes that record the current record.

Lookup

Retrieves field values from a record that matches specified search values.

OpenDatabase

Opens the database that contains the dataset.

Post

Writes a modified record to the database.

RevertRecord

Restores the current record in the dataset to an unmodified state when cached updates are enabled.

SortBy

Sorts opened dataset on client side without refetching data from server.

Translate

Converts a data string between the ANSI character set used by Delphi (and Windows), and the local code page (OEM character set).

UpdateStatus

Reports the update status for the current record.

Derived from TmySQLQuery

Create

Creates an instance of a query component.

Destroy

Destroys the instance of a query.

ExecSQL

Executes the SQL statement for the query.

GetDetailLinkFields

Fills lists with the master and detail fields of the link.

ParamByName

Accesses parameter information based on a specified parameter name.

Prepare

Sends a query for optimization prior to execution.

UnPrepare

Frees the resources allocated for a previously prepared query.

In TmySQLMacroQuery

Reopen

Reopens current query.

MacroByname

Returns Macros property item which property Name is equal to Value.