Record not found or changed by another user. How to solve it?

From: Hernando Duque C. (progresoft_at_tutopia.com)
Date: 06/24/04


Date: Thu, 24 Jun 2004 15:10:02 -0500

Hi,

I'm having big trouble with this exception: "Record not found or changed by
another user". I know it happens when the ApplyUpdates find differences
between the cached data values of the record and the actual values but this
is not the case.

I'm using SQL Server 2000, Delphi 6, ADO, TClientDataSet and
TDataSetProvider components. It seems as it happens randomly, some times
when records are appended but some other times when records are edited, but
always in the related table from a master detail relation.

I have worked around it for several days but I can't find the way to solve
it. Any help will be appreciated.

Thanks in advance.

Hernando.



Relevant Pages

  • Re: Boolean tests [was Re: Attack a sacred Python Cow]
    ... "len!= 0" will get you in trouble if somebody passes a string or a dictionary. ... With the exception of the "is" and "is not" operators, nothing in Python is guaranteed to work with any imaginable object. ... Yes, I know it breaks duck typing, which is why I do it only very rarely, and never with e.g. sequence types. ... If I use ifinstance for type checking, it's because I need some _very_ specific class, almost always one that I wrote. ...
    (comp.lang.python)
  • Re: Boolean tests [was Re: Attack a sacred Python Cow]
    ... "len!= 0" will get you in trouble if somebody passes a string or a dictionary. ... With the exception of the "is" and "is not" operators, nothing in Python is guaranteed to work with any imaginable object. ... Yes, I know it breaks duck typing, which is why I do it only very rarely, and never with e.g. sequence types. ... If I use ifinstance for type checking, it's because I need some _very_ specific class, almost always one that I wrote. ...
    (comp.lang.python)
  • Error when attaching multiple files (System.web.mail)
    ... I am having some trouble using the MailMessage object to send an email with ... Exception has been thrown by the target of an invocation. ... When a user submits a file, it is stored directly to the database, and when ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SORN off the road?
    ... I think it's only in exception circumstances that you'll get into ... trouble. ... For example I had a kit car which I failed to update the address on the ... just write a letter explaining and I should be OK. ...
    (uk.rec.cars.maintenance)
  • Re: Accessing file while it is being copied
    ... The trouble is that if the app detects a new file before it has been fully copied from another location, and it starts processing, then I get errors. ... I tried to test for an exclusive file lock using NIO, ... If it throws this exception just wait for a few seconds and try again. ...
    (comp.lang.java.programmer)