Article View: borland.public.cppbuilder.database.ado
Article #5478Re: "Row cannot be located for updating..." ???
From: Alan Lichtenstein
Date: Fri, 20 Apr 2001 20:27
Date: Fri, 20 Apr 2001 20:27
36 lines
2083 bytes
2083 bytes
Be sure that the tables have a primary unique index.... Rhonda wrote in message <3ae05d01_2@dnews>... >Hello... > >I'm working on a database programming using Borland C++ Builder and an >Access database and have been running into a problem on several of my forms. > >I get the following error if I do one of the following 2 things with the >forms: > >1.) If I'm in a form and I change some of the fields that are attached to a >database and then I update the databaseand then change something else and >try to update again. > >2.) Or... if I add a new record and then after updating move to a different >record and come back to the new record and try to delete the new record > >The error message is: "Row cannot be located for updating. Some values may >have been changed since it was last read." > >The only work around that I have found is to do the following in my update >code: Save the current row, close the dataset, re-open the dataset , and >then to relocate the row. It's not pretty! > >I have searched the web and found several other people with this same error >and no solution. I'm hoping that someone can help. > >Thanks! >~Rhonda~ > >
Technical Details
Message-ID:
<3ae09baf$1_1@dnews>Path:
arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out-sjo.usenetserver.com!cyclone.bc.net!logbridge.uoregon.edu!hammer.uoregon.edu!feed.textport.net!news.bnb-lp.com!dnewsReferences:
<3ae05d01_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,e914ab10c95373d4 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-04-20 13:42:03 PST From: "Alan Lichtenstein" <alanl@sss.sungard.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3ae05d01_2@dnews> Subject: Re: "Row cannot be located for updating..." ??? Date: Fri, 20 Apr 2001 16:27:28 -0400 Lines: 38 Organization: SunGard X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 NNTP-Posting-Host: 198.62.209.10 Message-ID: <3ae09baf$1_1@dnews> X-Trace: dnews 987798447 198.62.209.10 (20 Apr 2001 13:27:27 -0700) Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out-sjo.usenetserver.com!cyclone.bc.net!logbridge.uoregon.edu!hammer.uoregon.edu!feed.textport.net!news.bnb-lp.com!dnews