Article View: comp.lang.pascal.delphi.databases
Article #122Why isn't TBatchMove creating a key violations table? Anyone?
From: Bill Artemik
Date: Tue, 04 Aug 1998 00:00
Date: Tue, 04 Aug 1998 00:00
31 lines
2140 bytes
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-mailShow 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