The same old 'Row cannot be located for updating....'

Posted on 2004-11-15
Last Modified: 2010-04-04

I am using D6 and Intraweb.

In the application, I have one ADOconnection component and 36 ADOtable components.

Things seem to work just fine until more than one person is accessing the web appliction built with these components.

I do not use an ADODataset component.

I tried  ADOTable1.Properties['Update Criteria'].value := adCriteriaKey;   but adCriteriaKey generates an 'undeclared variable'


Question by:4hplus
    LVL 1

    Expert Comment

    Does the file have right privlidges for multi user.

    Maybe create a kind of buffer to interact between the two Client(S) > Buffer > File?

    Sounds simply like a sharing conflict try adapting you code & re-think the interaction between client,  code, DB Util, and file

    Might solve it i dunno just a suggestion
    LVL 6

    Expert Comment

    are there any triggers for that table? I too faced the same problem once, and after spending a lot of time, i found that a trigger was causing the problem.
    LVL 13

    Expert Comment

    Row cannot be located for updating....

    just refers to primary keys missing from the table you are trying to update, the code needs that to be able to resolve back to the record that was being edited

    Author Comment

    I have solved the problem:

    The solution was to issue the following command the instant I opened one of the data tables (I never change the value of the
    key field)

    ADOTableXX.Properties['Update Criteria'].value := adCriteriaKey;  {Constant found in ADOInt unit}  Where XX is the
    ADOTable component number.  The default update criteria is to check for changes in all fields (columns).  adCriteriaKey
    forces the ADO to just check the key field.

    This is not a component static property, it must be set dynamically.

    During intense testing, the 'row cannot be located for updating....' error message was never issued again.

    Thanks All



    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
    In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    This video discusses moving either the default database or any database to a new volume.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now