====== Case: Cached Updates ====== 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. ===== Implementation details ===== For this demo the form create event is used to start Marshal automatically. Here is the code:\\ uses dmMainComp, VCL.SE.RTTK.Marshal, //Reference to the Marshal Unit Vcl.Clipbrd; //used to copy query to clipboard {$R *.dfm} procedure TfrmCachedUpdates.FormCreate(Sender: TObject); begin inherited FormCreate(Sender); RegisterDS(qryProducts); TSERTTKWorker.ShowMarshal; //added to start Marshal end; ===== Recreation ===== Start the demo sample Qry_CachedUpdates. Dock the Marshal form right and the query form left. - Ordered List ItemConnect to the SQLite_Demo database. - Click the button "Copy query to clipboard". - On the Marshal form expand dmlmaincomp and click on dbmain to inspect the database connection. - Paste the query in the "Query Tool" tab and then click execute to run the query. - Expand frmCachedUpdates and select qryProducts, then select the dataset grid tab to browse the dataset.