🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #5478

Re: "Row cannot be located for updating..." ???

#5478
From: Alan Lichtenstein
Date: Fri, 20 Apr 2001 20:27
36 lines
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!dnews
References: <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