Questions on ApplyUpdates, CommitUpdates

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

Article #494

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#494

From: Howard Lee Harkness
Date: Fri, 07 Sep 2001 14:34

26 lines
2219 bytes

Mark Cashman <mcashman@temporaldoorway.com> wrote:

>Make sure you have CachedUpdates = true, and in the AfterPost event do
>ApplyUpdates() and CommitUpdates().

This is a bit unclear.  From the help files, I gather that
ApplyUpdates() writes the cache out to somewhere, and CommitUpdates()
is misnamed, and only clears the cache.

So if I make some changes, call ApplyUpdates(), then CommitUpdates(),
then makes some changes, repeat the ApplyUpdates() and
CommitUpdates(), *then* call the Database->Commit(), will the first
changes get commited to the database?

Also, if I want to cancel the changes to just one TQuery resultset, do
I need to call TQuery::Cancel(), TQuery::CommitUpdates(), or both, or
something else?

In the help files, the example shows to ApplyUpdates(), then call the
database Commit(), then CommitUpdates().  Is that sequence actually
required?

TIA for you help.

Spam Me and Get Sued <harkness@suespammers.org>
see www.suespammers.org for details & free spam-nuking email account

Technical Details

Message-ID: <mmmhptoq8jrmtnlln3si9h9t2vmfsun22p@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

References:

<h2n65t43f0hk3svu8lp2v4j31nkk8bjjrs@4ax.com> <3A53B9CD.4D9FA179@freenet.co.uk> <mf395tcc6pjv22kom13vh70ms90ivnu7ti@4ax.com> <3A54A62B.28F98F65@freenet.co.uk> <e696ntomanipk4oi4surrjo1j81jsrkime@4ax.com> <3B73C59F.2A438336@temporaldoorway.com> <6p38nt4tc31scf3m8ufsl5pd0nuhv7lp2g@4ax.com> <3B7A5939.91D95B8B@temporaldoorway.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,f125cee301e69e65
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-09-07 07:41:33 PST
From: Howard Lee Harkness <harkness@suespammers.org>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Questions on ApplyUpdates, CommitUpdates
Date: Fri, 07 Sep 2001 09:34:33 -0500
Organization: YGBSM!
Message-ID: <mmmhptoq8jrmtnlln3si9h9t2vmfsun22p@4ax.com>
References: <h2n65t43f0hk3svu8lp2v4j31nkk8bjjrs@4ax.com> <3A53B9CD.4D9FA179@freenet.co.uk> <mf395tcc6pjv22kom13vh70ms90ivnu7ti@4ax.com> <3A54A62B.28F98F65@freenet.co.uk> <e696ntomanipk4oi4surrjo1j81jsrkime@4ax.com> <3B73C59F.2A438336@temporaldoorway.com> <6p38nt4tc31scf3m8ufsl5pd0nuhv7lp2g@4ax.com> <3B7A5939.91D95B8B@temporaldoorway.com>
X-Newsreader: Forte Agent 1.8/32.548
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 207.136.49.211
X-Trace: dnews 999873349 207.136.49.211 (7 Sep 2001 07:35:49 -0700)
Lines: 26
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message