🚀 go-pugleaf

Hi,

Use one more TUpdateQuery, link it in code to the query you are updating
(through object inspector you can connect only one update sql) and use this
second TUpdateSQL to update the second table

Details are there in the On-line help on Using Cached Updates.....

Hope this helps

Salim
Jo�o Paulo Carvalho wrote in message <371FB3B4.AC2F6733@triang.com.br>...
>I made a query(with TQuery) in two tables, and i wanna update that
>query; so, i use an TUpdateSQL component. But the 'update code'(or the
>ins, or del code) that i can put in that component don't accept(by the
>defualt SQL lang) 2 names of tables....
> The schema(TQuery + TUpdateSQL + cached updates) suggested in CB docs,
>is what I found better of using, but those problems exists. I just can't
>tell to BDE my 2 tables names; or even pass to it, 2 SQL commands that
>make my update/del/ins!
>
> So to override this problem, i need to use an TQuery for my query, and
>3 others TQuery components to make the ins, del, update code execute in
>the database for each table used in main query(TQuey).... in that case
>6+1= seven TQuery components, just to do this!
>
> well,... The CB docs recommend to use the technique of TUpdateSQL and
>cached updates, and teoretically it's the easiest way. But i can't make
>it works for more than one table!!!
>
> how can i make the TUpdateSQL works fine???