Append Key Violations

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

Article #1674

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

#1674

From: Robert Emmons
Date: Wed, 24 Mar 2004 23:21

12 lines
1478 bytes

I am using a TADOQuery to insert records in a Microsoft Access 2000
(MSA) database table.  If I run the query in MSA I get the opportunity
to ignore any key violations and append the records which do not
create key violations.  However, I see no such option in the TADOQuery
class.  If there is a single key violation, it refuses to append *any*
of the records.

My work around is to use a select and delete query to delete the key
violation records, but I'd prefer a simpler way.

Is there a way or property to set the TADOQuery to append the records
without key violations, and omit those with violations?

Technical Details

Message-ID: <oe5460dfppnhmbe99n4500cudggmntqhet@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ffb97565c8ce78b9,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-03-24 15:35:10 PST
From: Robert Emmons <remmons@aurigen.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Append Key Violations
Date: Wed, 24 Mar 2004 18:21:15 -0500
Message-ID: <oe5460dfppnhmbe99n4500cudggmntqhet@4ax.com>
X-Newsreader: Forte Agent 1.93/32.576 English (American)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 68.193.14.50
X-Trace: newsgroups.borland.com 1080170273 68.193.14.50 (24 Mar 2004 15:17:53 -0800)
Lines: 13
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!newsfeed.iinet.net.au!newsfeed.iinet.net.au!PeerFeed.KWeb.on.ca!news.kweb.on.ca!newsgroups.borland.com!not-for-mail