title: Lazarus, can't get DB Update working. How can I preview whats being submitted?
body: <p>Hi I have a form setup using TMySQL51Connection, TSQLTransaction &amp; TSQLQuery modules, it retrieves info from the DB without issue but I'm having problems with updates.</p>
  
  <p>The DB is pretty large so I'm starting with just the 1st couple of rows, once they're working I'll extend the query.</p>
  
  <p>My TSQLQuery.UpdateSQL is as follows</p>
  
  <pre><code>UPDATE table SET
  ContactFirst = :ContactFirst,
  ContactSur = :ContactSur
  WHERE AccountID = :AccountID
  </code></pre>
  
  <p>Then I have a button in my form, the onCLick event contains:</p>
  
  <pre><code>begin
      accSelect.Edit;
      accSelect.Post;
      accSelect.ApplyUpdates;
      dbTransaction.CommitRetaining;
      sqlbl1.Caption := accSelect.UpdateSQL;
  end;
  </code></pre>
  
  <p>Clicking the buttons does precisely nothing with the DB, it generates no error messages, just updates the caption on sqlbl1. Is there anyway to preview what Lazarus is sending to the DB with values included so I can track down whats going wrong?</p>
  
  <p>I tried adding a logging event to the SQLConnection but couldn't work out how to get it generating logs.</p>