Re: How To Mantain Record Status when Batch Updating

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

Article #5450

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

#5450

From: Piero Salandin
Date: Mon, 07 May 2001 10:31

22 lines
1997 bytes

"Mario Alejandro" <mamcx@usa.net> ha scritto nel messaggio
news:3af48ba3_2@dnews...
> Do you do updatebatch in the CLIENT? Don't call updatebatch until save ok
> (in the server). If you system is not Client/Server, then do
> MyAdo.RecordSet.Clone(), assign the recorset to another adodataset, and do
> updatebatch (=Client/Server mimic)
>
>
Sorry, bu maybe I did'nt get the point.
First of all, my system IS Client/Server, in the way I am connecting to MS
SQL Server 7.0 via ADO.
The idea is to use batch update mode to have a consistent way of saving a
LUW by a begin transaction - save all recordsets - commit or rollback.

So, as theUpdatesBatch method actually sends the update queries to the
dtaabase, how can I save my data without issuing the UpdatesBatch? What do
you mean by saying not to call updatebatch until save ok? how do I save?

Please I'd appreciate an answer very much.

Piero

Technical Details

Message-ID: <3af68ce6_2@dnews>

Path:

arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!news-xfer.nuri.net!enews.sgi.com!newsxfer.eecs.umich.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp1.njy.teleglobe.net!teleglobe.net!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews

References: <3af44374_1@dnews> <3af48ba3_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f5cad,27870919545ae7a4
X-Google-Attributes: gidf5cad,public
X-Google-Thread: 10698b,27870919545ae7a4
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-05-07 05:00:02 PST
From: "Piero Salandin" <piero.salandin@libero.it>
Newsgroups: borland.public.cppbuilder.database.ado,borland.public.delphi.database.ado
References: <3af44374_1@dnews> <3af48ba3_2@dnews>
Subject: Re: How To Mantain Record Status when Batch Updating
Date: Mon, 7 May 2001 12:31:37 +0200
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: 151.25.118.243
Message-ID: <3af68ce6_2@dnews>
X-Trace: dnews 989236454 151.25.118.243 (7 May 2001 04:54:14 -0700)
Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!news-xfer.nuri.net!enews.sgi.com!newsxfer.eecs.umich.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nntp1.njy.teleglobe.net!teleglobe.net!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message