TMMUpdater

Class: TMMUpdater

Declared in: EDBMMClient (extends TMMClientBase)

Writes rows from a local EDB buffer table to a remote MySQL/MariaDB table via batch INSERT, UPDATE, or UPSERT.
Workflow: set properties → call Prepare → fill Table → call Execute.
The caller owns the instance and frees it; the destructor calls Drop automatically.

Member Overview

Properties Methods Events
Connection Prepare OnLog
Params Execute OnWarning
TargetTable Clear OnBlobUploadActive
Mode Drop OnProgress
Where Prefetch
UpdateColumns / UpdateColumnsList Cancel
Columns FormatFailedRowPK
Table
TempTableName
MaxBatchBytes
InlineThreshold
BlobChunkSize
SkipFKChecks
KeepTempTable
PrefetchComplete / PrefetchRowsLoaded / PrefetchError
Success
LastError
FailedRowPK
RowsInserted / RowsUpdated / RowsMatched
RowsAffected
RowsSent
ChunksSent
Cancelled

† Inherited from TMMClientBase.

Design-time Use

TMMUpdater is a TComponent descendant and can be placed on a form or data module from the component palette (EasyGate tab, Delphi 13).
All configuration properties (Connection, TargetTable, Mode, Where, UpdateColumnsList, Table, KeepTempTable, MaxBatchBytes, InlineThreshold, BlobChunkSize, SkipFKChecks, Params, OnLog, OnProgress, OnWarning, OnBlobUploadActive) are published and editable in the Object Inspector.
UpdateColumnsList shows a string list editor for the column filter at design time; it mirrors the runtime UpdateColumns property.

See EDBApiClient Library for the full design-time setup instructions.

See Also

(C) 2026 Easygate, Lda