You can use the DELETE DUPLICATES from your_table USING col1, col2, col3.... The command will compare only the columns that are specified and thus you can skip the AUTONUM column. If the USING option is not used, it will compare all columns including the AUTONUM, in which case, if the AUTONUM was properly used, will result in no duplicates found.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of William Stacy Sent: Thursday, February 13, 2003 4:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Duplicate Rows - More Information Chuck Finley wrote: > I am reading the information and setting it into variables vA1....vA32 and > then I read the next row into vB1....vB32. With 32 columns to compare the > If.. .vA1 = .vB1 and .vA2 = .vB2......VA32 = VB32 then..... runs pretty > slow. I was hopping for a better way! This file can be 10 K records per > month. Thank to those who have and will responded to my question. It should run pretty fast if you then do the deletions as a group, then step to the next row that exists. The delete duplications that others have suggested will not work if you have a unique autonum column. If you eliminate the autonum column, the del dupl should work. bill
