🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Error "Record modified by another user"

#1709
From: Jerry Bloomfield (TeamB)
Date: Fri, 13 Aug 1999 00:00
27 lines
1920 bytes
On Thu, 12 Aug 1999 17:55:15 +0200, "PIQUOT J�r�me" <wolff@media-net.fr>
wrote:

>when i apply updates from TClientDataSet i have an exception raised with
>this msg:"Record modified by another user".
>Could someone help to resolve this?

First of all,  are you positive that no one else is modifying your data
while your program is running?

Having said that,  I have recently responded to several people with the
same (or similar) error messages.  One thing to consider is that performing
equality tests on floating point values is not a wise thing to do.  Realize
that Date/Time, Currency, and such fields are often stored as floating
point values on many of the current database formats,  so using any fields
of that type on an equality test for an update may result in the error you
are getting if the field suffers from a "rounding error".  Some people can
solve this by changing their default UpdateMode to something other than
upWhereAll,  but that may not help you is the field you are changing is one
of the fields suffering from the rounding error,  or if it is a key field
(depending upon your choice for the UpdateMode)...

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: <37ba957d.458483384@forums.inprise.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <7ouqd6$fi211@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: JersWork@wwa.com (Jerry Bloomfield (TeamB))
Subject: Re: Error "Record modified by another user"
Date: 1999/08/13
Message-ID: <37ba957d.458483384@forums.inprise.com>
X-Deja-AN: 512117538
Content-Transfer-Encoding: 8bit
References: <7ouqd6$fi211@forums.borland.com>
Organization: LSVFA - Latest Software Version Freaks Anonomous
Content-Type: text/plain; charset=ISO-8859-1
Mime-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier