title: commit on MySql + Zeos lib
body: <p>I use next code to post some records on a non autocommin connection:</p>
  
  <pre><code>ZConnection1.AutoCommit := False;
  
    try
      ZTable1.Insert;
      ZTable1.FieldByName('name').AsString := 'John Doe';
      ZTable1.Post;
      ZConnection1.Commit;
    except
      ZConnection1.Rollback;
    end;
  </code></pre>
  
  <p>When I run this code nothing is saved on my database.</p>
  
  <p>After I try next code ...</p>
  
  <pre><code>ZConnection1.AutoCommit := False;
  
     with ZQuery1 do begin
        SQL.Text := 'INSERT INTO mytable (name) values ("John Doe")';
        ExecSQL;
        SQL.Text := SQL.Text + 'COMMIT' ;
        try
          ExecSQL;
        except
          SQL.Text := 'ROLLBACK';
          ExecSQL;
        end;
      end;
  </code></pre>
  
  <p>... all work perfect. </p>
  
  <p>What I do wrong on first case? I use Delphi6, MySql, Zeos library and InnoDB table.</p>