Delphi Ado update insert betwen 2 entries

I need to update records from one table to another (this is for the main table and f "is the same for the DetailTable.

first the record position of the table record that I want to copy is from:

Tabelamestre (Local_deste_cliente) (1 entry)

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

      

now I need to update / insert a record from Vibrometria: = Local_deste_cliente (TADOTABLE) Now I need to get the record above and do the same for 2 detail tables

    Vibrometria_Sub (J)  :=   Tabeladetail  (Variaveis_neste_local). ((J) Records 

      

and I have another table to get the master record from (K) Tabeladetail (Variaveis_neste_local)

Vibrometria_Sub1 (K)  :=   Tabeladetail1(Variaveis_neste_local1). ((k) Records

      

lest's say I need to update from 1 to N starting from the first table !!!!!!!!

there is a quick solution for this !!!!!!

thanks

+2


a source to share


1 answer


Create child records in the master dataset AfterInsert ().



Use the MasterSource and MasterFields property of the child dataset to automatically update records when the master record changes.

0


a source







All Articles