Paradox dilema ?

Article View: borland.public.delphi.database

Article #197

Back to borland.public.delphi.database Previous Next

#197

From: Ian Robinson
Date: Thu, 05 May 2005 11:49

31 lines
2024 bytes

Hi,

I must be missing the obvious here or cannot see the wood for trees, 
please help before they take me away !

I have a paradox table with 6 records. The first 2 records appear 
identical yet the primary index should be unique and disallow this.

To conform with etiquette I have not attached the table but have 
posted it with it's primary index to

www.forestsupport.com/partnos.db
www.forestsupport.com/partnos.px

(only 4kb each)

The problem seems to be that there is something in the second Supplier 
# field that I cannot identify but it is sufficient to cause the 2 
records to not be identical.

TIA


Best regards

Ian Robinson
FOREST DATA SUPPORT Ltd
                        +44(0)1594 564457 (Office)
                        +44(0)7718 806 006 (UK Mobile)
                        +34 653 209 592 (Overseas Mobile)
                        +44(0)1594 564038 (Out of hours support)

Technical Details

Message-ID: <d5d18b$cb8$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!dedekind.zen.co.uk!zen.net.uk!demorgan.zen.co.uk!194.72.9.35.MISMATCH!news-peer1!btnet-feed5!btnet!news.btopenworld.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 115d96,a8835a40ffef5cdd,start
X-Google-Attributes: gid115d96,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!dedekind.zen.co.uk!zen.net.uk!demorgan.zen.co.uk!194.72.9.35.MISMATCH!news-peer1!btnet-feed5!btnet!news.btopenworld.com!not-for-mail
From: "Ian Robinson" <forestsupport@btinternet.com>
Newsgroups: borland.public.delphi.database
Subject: Paradox dilema ?
Date: Thu, 5 May 2005 11:49:31 +0000 (UTC)
Organization: BT Openworld
Lines: 33
Message-ID: <d5d18b$cb8$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com>
NNTP-Posting-Host: host81-151-187-185.range81-151.btcentralplus.com
X-Trace: nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com 1115293771 12648 81.151.187.185 (5 May 2005 11:49:31 GMT)
X-Complaints-To: news-complaints@lists.btinternet.com
NNTP-Posting-Date: Thu, 5 May 2005 11:49:31 +0000 (UTC)
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MSMail-Priority: Normal