QueryDataSet.deleteAllRows fails

Article View: borland.public.jbuilder.database

Article #369

Back to borland.public.jbuilder.database Previous Next

#369

From: Whym Junction
Date: Thu, 07 Dec 2006 09:53

20 lines
1802 bytes

I'm trying to empty a table with the following code (some lines
regarding metadataupdate, tablename and rowid removed for brevity):


        queryDataSet1.setQuery(new QueryDescriptor(database1, "select *
from some_table", null, false,Load.ALL));
        queryDataSet1.setResolver(new QueryResolver());
        queryDataSet1.executeQuery();
        queryDataSet1.deleteAllRows();
        queryDataSet1.saveChanges();

The code raises a runtime DataSetException, error code BASE+38:
More than one row was affected by resolution query:DELETE FROM
`some_table`  WHERE `CaseID` = ?

I'm stumped. The resolution query seems OK. Did I forget something
obvious? 

Thanks in advance,
Wim

Technical Details

Message-ID: <1165485180.366318.31740@80g2000cwy.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!80g2000cwy.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1073da,1997d4d7825938bd,start
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!80g2000cwy.googlegroups.com!not-for-mail
From: "Whym Junction" <wmjanssen@gmail.com>
Newsgroups: borland.public.jbuilder.database
Subject: QueryDataSet.deleteAllRows fails
Date: 7 Dec 2006 01:53:00 -0800
Organization: http://groups.google.com
Lines: 21
Message-ID: <1165485180.366318.31740@80g2000cwy.googlegroups.com>
NNTP-Posting-Host: 194.151.158.193
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1165485186 21988 127.0.0.1 (7 Dec 2006 09:53:06 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 7 Dec 2006 09:53:06 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.8.0.8) Gecko/20061025 Firefox/1.5.0.8,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 80g2000cwy.googlegroups.com; posting-host=194.151.158.193;
   posting-account=Pz9y0w0AAADXMEg--RwOLJkBx8iyvRj3