Differences

This shows you the differences between two versions of the page.

--- rttk:uc:cacheupdates [2021/08/10 06:09] – created wikiadmin
+++ rttk:uc:cacheupdates [2021/08/10 06:29] (current) – [Recreation] wikiadmin
@@ Line 2: / Line 2: @@
 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 I use the form create event to start Marshal.  Here is the code:\\
+For this demo the form create event is used to start Marshal automatically.  Here is the code:\\
 <code pascal>uses
-  dmMainComp,   VCL.SE.RTTK.Marshal, Vcl.Clipbrd;
+  dmMainComp,
+  VCL.SE.RTTK.Marshal, //Reference to the Marshal Unit
+  Vcl.Clipbrd; //used to copy query to clipboard
 {$R *.dfm}
@@ Line 12: / Line 14: @@
   inherited FormCreate(Sender);
   RegisterDS(qryProducts);
-  TSERTTKWorker.ShowMarshal;
+  TSERTTKWorker.ShowMarshal; //added to start Marshal
 end;</code>
 ===== Recreation =====
-Start the demo sample Qry_CachedUpdates.
+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.