🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Error "Record modified by another user"

#1578
From: PIQUOT J�r�me
Date: Tue, 17 Aug 1999 00:00
45 lines
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-mail
References: <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