Article View: borland.public.cppbuilder.database.multi-tier
Article #1578Re: Error "Record modified by another user"
From: PIQUOT J�r�me
Date: Tue, 17 Aug 1999 00:00
Date: Tue, 17 Aug 1999 00:00
45 lines
2516 bytes
2516 bytes
thanks for your answer. -- ----------------------------------------------------------------- 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 ----------------------------------------------------------------- Jerry Bloomfield (TeamB) <JersWork@wwa.com> a �crit dans le message : 37b8db76.541932617@forums.inprise.com... > On Fri, 13 Aug 1999 10:27:00 +0200, "PIQUOT J�r�me" <wolff@media-net.fr> > wrote: > > >thanks for your reply but i do not perform equlity test. this exception > >happens while i call Provider ApplyUpdates. > > Well, depending on how you have your UpdateMode set, you may be > performing an equality test that you do not realize you are. If you have > the UpdateMode set to upWhereAll, you will perform an equality test on > every field in the record... By setting the UpdateMode to upWhereKey, it > will perform the equality test on the key fields only, and upWhereChanged > will only compare against the fields which were changed. > > For most instances, upWhereKey is sufficient when your table has a unique > index or key field. upWhereAll is overkill in those cases, as the > key/index field guarantee uniqueness. I am sure there is a valid reason > for upWhereChanged, but I can not think of one right now... :) > > If your table has a unique key/index, and you do not use any of the field > types I mentioned earlier (Date/Time, Currency, Float, Double, etc) then > you can set the UpdateMode to upWhereKey and quite probably resolve your > problem... > > Jerry Bloomfield (TeamB) > -- > Jerry Bloomfield JersWork@wwa.com > Proud Member of Borland's TeamB > "We'll do anything if you don't pay us."
Technical Details
Message-ID:
<7pb3su$rak10@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> <37b8db76.541932617@forums.inprise.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/17 Message-ID: <7pb3su$rak10@forums.borland.com> X-Deja-AN: 513706858 References: <7ouqd6$fi211@forums.borland.com> <37ba957d.458483384@forums.inprise.com> <7p0kig$h8f4@forums.borland.com> <37b8db76.541932617@forums.inprise.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