Delphi / Object Pascal · Database exception

EUpdateError Exception

What does EUpdateError Exception mean in Delphi / Object Pascal?

Raised when a dataset provider (TDataSetProvider or a custom IProviderSupport implementation) fails to apply an update - an insert, edit, or delete pushed from a client dataset back to the underlying data - during an ApplyUpdates cycle.

EUpdateError ExceptionDelphi (VCL) · Delphi (FireMonkey)

Condition

Raised when a dataset provider (TDataSetProvider or a custom IProviderSupport implementation) fails to apply an update - an insert, edit, or delete pushed from a client dataset back to the underlying data - during an ApplyUpdates cycle.

Fix

Handle the provider's OnUpdateError event to inspect the failing record and error, and decide per-record whether to retry, skip, or abort the ApplyUpdates batch rather than letting the whole batch fail on one bad row.

Related database exception