Article View: borland.public.cppbuilder.database.multi-tier
Article #1709Re: Error "Record modified by another user"
From: Jerry Bloomfield (TeamB)
Date: Fri, 13 Aug 1999 00:00
Date: Fri, 13 Aug 1999 00:00
27 lines
1920 bytes
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-mailReferences:
<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