Cached updates can be difficult to understand / diagnose, Marshal allows you to look at the dataset and database at the same time to understand what is pending and written to the actual database.

For this demo I use the form create event to start Marshal. Here is the code:

uses
  dmMainComp,   VCL.SE.RTTK.Marshal, Vcl.Clipbrd;
 
{$R *.dfm}
 
procedure TfrmCachedUpdates.FormCreate(Sender: TObject);
begin
  inherited FormCreate(Sender);
  RegisterDS(qryProducts);
  TSERTTKWorker.ShowMarshal;
end;

Start the demo sample Qry_CachedUpdates.