Re: QueryDataSet.deleteAllRows fails

Article View: borland.public.jbuilder.database

Article #372

Back to borland.public.jbuilder.database Previous Next

#372

From: John Moore (TeamB)
Date: Tue, 12 Dec 2006 19:50

28 lines
2015 bytes

Whym Junction wrote:

> I found a solution for this problem. There were had duplicate records
> in my dataset, and there was no key set. 

You should definitely fix that.. poor database design..


> Dx breaks the above query into
> smaller pieces; it tries to delete records one at a time. The solution
> is to make sure the records are different in at least one field or by
> adding a unique key field. I'll report here if I find a way to prevent
> the one-at-a-time delete strategy.

Consider stored procedures..

I would never dream of using "deleteAll" except on a very, very small 
table..

John..

-- 
=============================================
TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
====================================================

Technical Details

Message-ID: <457f07c3$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news1.google.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<1165485180.366318.31740@80g2000cwy.googlegroups.com> <4579d5c6$1@newsgroups.borland.com> <1165912689.617825.255200@f1g2000cwa.googlegroups.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1073da,1997d4d7825938bd
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 12 Dec 2006 11:50:29 -0800
From: "John Moore (TeamB)" <jbm@microps.com>
User-Agent: Thunderbird 1.5.0.8 (Macintosh/20061025)
MIME-Version: 1.0
Newsgroups: borland.public.jbuilder.database
Subject: Re: QueryDataSet.deleteAllRows fails
References: <1165485180.366318.31740@80g2000cwy.googlegroups.com> <4579d5c6$1@newsgroups.borland.com> <1165912689.617825.255200@f1g2000cwa.googlegroups.com>
In-Reply-To: <1165912689.617825.255200@f1g2000cwa.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 207.137.13.178
Message-ID: <457f07c3$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1165952963 207.137.13.178 (12 Dec 2006 11:49:23 -0700)
Lines: 28
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news1.google.com!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message