🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

How to use Requery with ADOTable component...

#3346
From: MarkR
Date: Sun, 06 Oct 2002 15:50
27 lines
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-mail

Show 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