Board index » delphi » ADO, JOINS and UPDATE or INSERT

ADO, JOINS and UPDATE or INSERT

Hay,

 I have one problem. I read a lot on news groups and I can't find the right
answer. Ok I know that if I delete some record form recordset whereSQL
statemant is some JOIN I can use
 AQ.Recordset.Properties['Unique Table'].Value:='table1';  and it works
fine.
 I also read that this function don't work for update or insert .

I have SQL like
select t1.*,t3.naziv
from table1 t1 LEFT OUTER JOIN table3 t3 ON (t1.ID_TABLE=t3.ID_TABLE)

 Okey now I modifed some value in this recordset but I want that only fileds
from table1 will be posted and not also in table3.What must I do. Can
somebody tell me the whole procedure. I try with

 AQ.Recordset.Properties['Resync Command'].Value:=AQ.SQL.Text;
 AQ.Recordset.Properties['Unique Table'].Value:='table1';

but it does not works

I hope that somebody can help me

 

Re:ADO, JOINS and UPDATE or INSERT


Take a look at TBetterADODataSet
http://web.orbitel.bg/vassil/

The main reason for the existence of this component is
to solve the problem you have.

HTH
--
Vassil Nazarov
IT Manager, Sofia Cable SA

Other Threads