Article View: borland.public.cppbuilder.database.ado
Article #3346How to use Requery with ADOTable component...
From: MarkR
Date: Sun, 06 Oct 2002 15:50
Date: Sun, 06 Oct 2002 15:50
27 lines
2056 bytes
2056 bytes
I have a very simple app which has an ADOTable component, a DBGrid control which holds all the key records, and a selection of DBEdit controls which allow indiviual fields to be edited, All these are also connected to a DBNavigate control. The database is MSAccess2000. Basically, I want to have two of the same app running on the same machine at the same time. When I do this, everything is fine until I delete a record in one app, and then do a ADOTable1->Requery() on the second app, I get an error saying --------------------------- Debugger Exception Notification --------------------------- Project caldervale.exe raised exception class EOleException with message 'Key value for this row was changed or deleted at the data store. The local row is now deleted'. Process stopped. Use Step or Run to continue. What do I need to do so that the second app doesn't fall over? -- BCB Version = 6 (sp2) Professional O/S Windows XP Prof ------------------------------------------------------ "There are 10 types of people in the World, those that understand binary, and those that don't." [Thanks to TheFatBoy-UMD]
Technical Details
Message-ID:
<3da05be0@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,722a814132e5ee2a,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-10-06 09:08:03 PST From: "MarkR" <mark.richards8@wapthespamntlworld.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: How to use Requery with ADOTable component... Date: Sun, 6 Oct 2002 16:50:55 +0100 Lines: 29 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 213.107.142.213 Message-ID: <3da05be0@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1033919456 213.107.142.213 (6 Oct 2002 08:50:56 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail