🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #1775

TUpdate SQL not works with >=2 tables!!

#1775
From: 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???
Technical Details
Message-ID: <371FB3B4.AC2F6733@triang.com.br>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show 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