delphi Ado update insert betwen 2 records
- by user315957
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
