delphi Ado update insert betwen 2 records

Posted by user315957 on Stack Overflow See other posts from Stack Overflow or by user315957
Published on 2010-04-13T22:57:56Z Indexed on 2010/04/13 23:13 UTC
Read the original article Hit count: 270

Filed under:
|

i nead to update recordes from one table to the other (this for the master Table and f«the same for the DetailTable.

first a posicion the record of the record´s of the table i whant to copy update from:

Tabelamestre(Local_deste_cliente) (1 record ) 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 the record´s from Vibrometria := Local_deste_cliente (TADOTABLE) Now i nead to get the record above and do the same for the 2 detail tables

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

and i stil have another table thar get a master record from (K) Tabeladetail (Variaveis_neste_local)

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

lest´s say i nead to update 1 to N starting in the first table!!!!!!!!

is there a fast solucion for this!!!!!!

Thanks

© Stack Overflow or respective owner

Related posts about delphi

Related posts about datasets