title: delphi Ado update insert betwen 2 records
body: <p>I need to update records from one table to the other (this for the master Table and f«the same for the DetailTable.</p>
  
  <p>first a position the record of the record´s of the table I want to copy update from:</p>
  
  <p>Tabelamestre(Local_deste_cliente) (1 record )</p>
  
  <pre><code>NInterv.text:=dbedit1.text;
  
   Begin
     with  ADOTable_casa do  
        Begin
          Close;
          SQL.Clear;
          SQL.Add('SELECT * from  Vibrometria_');
          SQL.Add('Where numeracao LIKE ''%'+NInterv.text );
          Open;
         end;
   end
  </code></pre>
  
  <p>now i need to update/insert  the record´s from  <strong>Vibrometria :=  Local_deste_cliente  (TADOTABLE)</strong>
  Now i need to get the record above and do the same for the 2 detail tables</p>
  
  <pre><code>    Vibrometria_Sub (J)  :=   Tabeladetail  (Variaveis_neste_local). ((J) Records 
  </code></pre>
  
  <p>and i stil have another table thar get a master record from (K)  Tabeladetail  (Variaveis_neste_local)</p>
  
  <pre><code>Vibrometria_Sub1 (K)  :=   Tabeladetail1(Variaveis_neste_local1). ((k) Records
  </code></pre>
  
  <p>lest´s say i need to update 1 to N starting in the first table!!!!!!!!</p>
  
  <p>is there a fast solution for this!!!!!!</p>
  
  <p>Thanks</p>