Article View: borland.public.cppbuilder.database.multi-tier
Article #1582Re: Error "Record modified by another user"
From: PIQUOT J�r�me
Date: Wed, 18 Aug 1999 00:00
Date: Wed, 18 Aug 1999 00:00
45 lines
2548 bytes
2548 bytes
I will use the Provider BeforeUpdateRecord to handle this. thanks -- ----------------------------------------------------------------- PIQUOT J�r�me A. WOLFF SA 6, rue de la Gare 67120 ERNOLSHEIM/BRUCHE FRANCE e-mail: wolff@media-net.fr http://www.media-net.fr/wolff ----------------------------------------------------------------- Matt Jacobs <mattja@ix.netcom.com> a �crit dans le message : 7pd65r$jr8@forums.borland.com... > If concurrency is not an issue for you. For instance, if you know no > one but yourself will be editing the records you are editing, then > what you can do is change the UpdateMode from UpWhereAll to > UpWhereKeyOnly. As long as your primary key is not a floating point or > datetime field (hidden floating point), then you will be okay. > UpWhereChanged in not usually a lot of help. It has the potential to > decrease the odds you will have the edit error, but it does not solve > the problem. UpWhereChanged can decrease the complexity of the WHERE > clause in the SQL statement that is generated, but in order to know > what changed, the BDE still must perform an internal comparison. If > this comparison contains floating point values, then the possibility > exists the rouding error will take place there, inside the bowels of > the BDE (which is the most likely place for the error). > > On the other hand, if you and someone else perform concurrent edits on > these same records, you need another solution. UpWhereKeyOnly will not > help you because you need UpWhereChanged so you will be notified the > record was actually changed by someone else while you were editing it > yourself. > > Matt Jacobs > > > > -- > > My reply-to address is purposely mangled to thwart auto-reply bots. > Please remove the two leading underscores if you wish to reply via > e-mail. >
Technical Details
Message-ID:
<7pdseu$18811@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7ouqd6$fi211@forums.borland.com> <37ba957d.458483384@forums.inprise.com> <7p0kig$h8f4@forums.borland.com> <7pd65r$jr8@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fcd2b,835c276b5b3c4b94 X-Google-Attributes: gidfcd2b,public From: "PIQUOT J�r�me" <wolff@media-net.fr> Subject: Re: Error "Record modified by another user" Date: 1999/08/18 Message-ID: <7pdseu$18811@forums.borland.com> X-Deja-AN: 514137189 References: <7ouqd6$fi211@forums.borland.com> <37ba957d.458483384@forums.inprise.com> <7p0kig$h8f4@forums.borland.com> <7pd65r$jr8@forums.borland.com> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Organization: WOLFF SA X-MSMail-Priority: Normal Reply-To: "PIQUOT J�r�me" <wolff@media-net.fr> Newsgroups: borland.public.cppbuilder.database.multi-tier