Article View: borland.public.cppbuilder.database.multi-tier
Article #1775TUpdate SQL not works with >=2 tables!!
From: Jo�o Paulo Carvalho
Date: Thu, 22 Apr 1999 00:00
Date: Thu, 22 Apr 1999 00:00
19 lines
1522 bytes
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???
Technical Details
Message-ID:
<371FB3B4.AC2F6733@triang.com.br>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,e1287b02ccaaa635,start X-Google-Attributes: gidfcd2b,public From: "Jo�o Paulo Carvalho" <jones@triang.com.br> Subject: TUpdate SQL not works with >=2 tables!! Date: 1999/04/22 Message-ID: <371FB3B4.AC2F6733@triang.com.br> X-Deja-AN: 469763342 Content-Transfer-Encoding: 7bit Organization: Another Netscape Collabra Server User Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.multi-tier