🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.pascal.delphi.databases
Article #122

Why isn't TBatchMove creating a key violations table? Anyone?

#122
From: Bill Artemik
Date: Tue, 04 Aug 1998 00:00
31 lines
2140 bytes
I am using Delphi 3.01 and paradox tables, bde 4.51

When I attempt to batchmove one table to another there are occasions
when I get Key violations. I have abort on KeyViol to False and have
given a name to the KeyViolTable of 'Dupes.db'.  I am using batAppend
as the mode.

When I execute the batchmove and key violations occur NO table is
created. I've looked on every local drive I have running. Nothing.

My test application is set up to display a grid of these "duplicate"
records but (although the KeyVoilCount is 23 in my test run) there is
NO table created. No updates occur (all of the temp table records are
in the master table so I should get SOMETHING!)

I've tried setting the Private dir to the exe directory, I've pointed
everything the the application directory. I've used Files/Search and
searched ALL local drives for DUPES.DB but Nothing!

Can Anyone help here? What am I doing wrong? I need to show the user
the duplicate records for some action and I can't get the db engine to
help out.

Any assistance is appreciated!

Thanx.

Bill Artemik
Programmer / Analyst
Wakefield Engineering, Inc.
bartemik@wakefield.com
Technical Details
Message-ID: <35c746c7.114462154@news1.newscene.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,6122878e583af5a7,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: ff75c,6122878e583af5a7,start
X-Google-Attributes: gidff75c,public
X-Google-Thread: 10de66,6122878e583af5a7,start
X-Google-Attributes: gid10de66,public
X-Google-Thread: 1043cf,6122878e583af5a7,start
X-Google-Attributes: gid1043cf,public
From: bartemik@wakefield.com (Bill Artemik)
Subject: Why isn't TBatchMove creating a key violations table? Anyone?
Date: 1998/08/04
Message-ID: <35c746c7.114462154@news1.newscene.com>
X-Deja-AN: 377883275
Content-Transfer-Encoding: 7bit
Organization: Newscene Public Access Usenet News Service (http://www.newscene.com/)
Content-Type: text/plain; charset=us-ascii
MIME-Version: 1.0
Reply-To: bartemik@wakefield.com
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.objectpascal,borland.public.delphi.database.sqlservers,borland.public.delphi.database.desktop