Article View: borland.public.cppbuilder.database.ado
Article #4426Re: Duplicate records
From: Gary Desroches
Date: Wed, 26 Dec 2001 14:45
Date: Wed, 26 Dec 2001 14:45
33 lines
1983 bytes
1983 bytes
I agree, the database should have a key field or at least an index which is set to "NoDuplicates" this forces at least one field in each record to be unique. You will get an exception on posting a duplicate value which the user must then change. "Rick Golden" <GoldenRick@hotmail.com> wrote in message news:3c224a5d_2@dnews... > like Jim said you can do that with SQL > but why not constraints to assure Database integrity???? > > > Jim Young <jyoung@youngendeavors.com> wrote in message > news:3c2221d1$2_1@dnews... > > I'm not aware of any function that does this. You could do this > > programatically using SQL. > > > > Jim > > > > "FretBuzzz" <none@none.com> wrote in message news:3c21f9a7_2@dnews... > > > Hi, > > > Does anyone know of a function that will delete duplicate entries in a > > > database table. > > > I want to be able to achieve this without the use of keys etc. > > > Thanks in advance, > > > FretBuzzz > > > > > > > > > > > >
Technical Details
Message-ID:
<a0cndi$sdt$1@nntp9.atl.mindspring.net>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!nntp.abs.net!feeder.qis.net!washdc3-snh1.gtei.net!news.gtei.net!news.mindspring.net!not-for-mailReferences:
<3c21f9a7_2@dnews> <3c2221d1$2_1@dnews> <3c224a5d_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,add4b0d12dd2238b X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-12-26 06:39:02 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!nntp.abs.net!feeder.qis.net!washdc3-snh1.gtei.net!news.gtei.net!news.mindspring.net!not-for-mail From: "Gary Desroches" <gcdesroches@mindspring.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: Duplicate records Date: Wed, 26 Dec 2001 08:45:20 -0600 Organization: MindSpring Enterprises Lines: 35 Message-ID: <a0cndi$sdt$1@nntp9.atl.mindspring.net> References: <3c21f9a7_2@dnews> <3c2221d1$2_1@dnews> <3c224a5d_2@dnews> Reply-To: "Gary Desroches" <gcdesroches@mindspring.com> NNTP-Posting-Host: d1.56.36.13 X-Server-Date: 26 Dec 2001 14:38:42 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200