TUpdate SQL not works with >=2 tables!!

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Jo�o Paulo Carvalho Thu, 22 Apr 1999 00:00

#1775

Author: Jo�o Paulo Carvalho
Date: Thu, 22 Apr 1999 00:00

19 lines
1522 bytes

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???

Re: TUpdate SQL not works with >=2 tables!!

#1779

Author: Salim
Date: Tue, 27 Apr 1999 00:00

31 lines
1871 bytes

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???

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads