title: Can changes made to a TFDMemTable cloned from a TFDQuery be sent back to the database?
body: <p>With Delphi 10 Seattle I am attempting to clone a <code>TFDQuery</code> with a <code>TFDMemTable</code> and persist the changes made in the <code>TFDMemTable</code> through to the database. </p>
  
  <p>The memtable changes appear in the query but don't go all the way to the DB. If I modify values in the query directly they do get saved in the database.</p>
  
  <pre><code>var
    query : TFDQuery;
    memtable : TFDMemTable;
  begin
    { run TFDQuery }
    query := TFDQuery.Create(nil);
    query.SQL.Text := 'select * from employee';
    query.Open;
  
    { clone query into memtable }
    memtable := TFDMemTable.Create(nil);
    memtable.CloneCursor(query);
  
    { go to the same record in query and memtable }
    memtable.First;
    query.First;
    Assert(memtable.Fields[0].Value = query.Fields[0].Value);
  
    { edit the record in the memtable from ABC to XYZ }
    Assert(memtable['SomeField'] = 'ABC');
    memtable.Edit;
    memtable['SomeField'] := 'XYZ';
    memtable.Post;
  
    { verify record also changed in query }
    Assert(query['SomeField'] = 'XYZ');
  
    { has the change gone through to the database? }
    query.Close;
    query.Open;
    query.First;
    Assert(query['SomeField'] = 'XYZ');  // assertion fails, value is still ABC
  </code></pre>