title: How to achieve independent cloned TADODataSet?
body: <p>The scenarios is like this:</p>
  
  <p>We have some SQL table. We are performing an SQL query on this table and we have results in TADOQuery object.</p>
  
  <pre><code>var
    qryOryginal, qryClone: TADOQuery;
  
  begin
    //setup all the things here
    qryOryginal.Active := True;
    qryClone.Clone(qryOryginal, ltBatchOptimistic);
    qryOryginal.Delete; //delete in qryOryginal casues that qryClone deletes its record too!
  end;
  </code></pre>
  
  <p>So, after cloning the DataSet my qryClone should hold and independent data(at least I thought so). However, performing Delete on qryOryginal causes the same operation on the qryClone. I don't want that.</p>
  
  <p>Any ideas?</p>
  
  <p>I know I could store the data elsewhere, in TClientDataSet perhaps but I would like to try the above solution first.</p>
  
  <p>Thanks in advance for your time.</p>