Crash on deleting an ADO db item

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

Article #1555

Back to borland.public.cppbuilder.database.ado Previous Next

#1555

From: Roland
Date: Fri, 14 May 2004 09:59

20 lines
1579 bytes

Hello,

I use an ADOQuery to select a certain item using SQL like this and do the following ...
ADOQuery1->SQL->Add("SELECT * FROM xxx order by Date asc");
ADOQuery1->First();
if(ADOQuery1->CanModify)
{
ADOQuery1->Delete();
}

In most cases it runs. But on DB's of a certain size I suddenly receive the error msg:

(germ.)Die Schluesselspalteninformationen sind ungenuegend oder inkorrekt. Es sind zu viele Zeilen von der Aktualisierung betroffen.

In English: The key column informations are insufficient or incorrect. Too much lines are affected by this actualisation.

I found some information that posting 'SET NOCOUNT ON' to the database could solve the problem. But how to be done? It is no common SQL statement.

Roland

Technical Details

Message-ID: <40a4986d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,4d1fce83fbeeab56
X-Google-Attributes: gid10698b,public
From: "Roland" <neubertNOSPAM@NOSPAMwst-gmbh.de>
Sender: "Roland" <neubertNOSPAM@NOSPAMwst-gmbh.de>
Reply-To: "Roland" <neubertNOSPAM@NOSPAMwst-gmbh.de>
Subject: Crash on deleting an ADO db item 
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 62.180.198.86     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <40a4986d$1@newsgroups.borland.com>
Date: 14 May 2004 02:59:09 -0700
X-Trace: newsgroups.borland.com 1084528749 207.105.83.66 (14 May 2004 02:59:09 -0700)
Lines: 21
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail