Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!njin!princeton!phoenix!englandr
From: englandr@phoenix.Princeton.EDU (Scott Englander)
Newsgroups: comp.databases
Subject: Deleting duplicate records
Message-ID: <9426@phoenix.Princeton.EDU>
Date: 15 Jul 89 18:26:03 GMT
Organization: Princeton University, NJ
Lines: 10

I'd like to delete duplicate records in a FoxBase file.  I tried setting
the index to unique and then copying the database to a new file, but the
duplicates remained.  I ultimately did it with a simple and SLOW program
that checked for duplicates and deleted them (as i'm typing, it's
running in the background under Multifinder -- there are 4000 records!).
But there must be a better way to do this using the unique index, since
only the first record with a given value of the index field is indexed.
-- 

                                               - Scott