Re: Update/Insert Rows from Join Table w/TADOQuery

Article View: borland.public.cppbuilder.database.ado

Article #4926

Back to borland.public.cppbuilder.database.ado Previous Next

#4926

From: Harold Howe (TeamB)
Date: Fri, 31 Aug 2001 03:11

17 lines
1565 bytes

Eric wrote:
> 
> How do you handle a table update/insert which is the result of a join
> query with ADO.  With the BDE you had TUpdateSql;

First, I would try the UpdateBatch mode of the ADO datasets. ADO's UpdateBatch mode
is kind of like cachedupdates (except it's not as good). I don't know if batch update
mode can resolve joins. I kind of doubt that it can.

If it can't, then you will need to manually execute separate sql statements to the
two tables. You could maybe put that sql inside of a single stored proc.

If you need to do this in lots of places, then you might want to create a component
for doing this. 

Harold Howe [TeamB]
http://www.bcbdev.com

Technical Details

Message-ID: <3B8F0061.75D33815@bcbdev.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!peer.news.opaltelecom.net!lon1-news.nildram.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

References: <3b86ef8d.266120250@forums.inprise.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,afdf806775500fe2
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-08-30 20:19:33 PST
Message-ID: <3B8F0061.75D33815@bcbdev.com>
Date: Thu, 30 Aug 2001 22:11:29 -0500
From: "Harold Howe (TeamB)" <hhowe@bcbdev.com>
X-Mailer: Mozilla 4.03 [en] (WinNT; I)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Update/Insert Rows from Join Table w/TADOQuery
References: <3b86ef8d.266120250@forums.inprise.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.22.227.236
X-Trace: dnews 999227416 24.22.227.236 (30 Aug 2001 20:10:16 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!peer.news.opaltelecom.net!lon1-news.nildram.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message