John - What you are seeing has to do with the EQNULL setting in the database.
If EQNULL is OFF then R:BASE cannot compare a null value in one record to the value in the same column in a different record so it will determine that the records are NOT duplicates and therefore will NOT delete the duplicate record. If you SET EQNULL ON then it WILL compare null values in the column list and if it's NULL in both, it will evaluate the same and delete one of the records. Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Croson Sent: Friday, July 18, 2008 1:50 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Interesting behavior Thanks, Bob. That's the odd thing: they ARE dups. I think I'm going to have to dump this, and start over again. Thank GOD we keep a copy of all flat files we import... On Fri, Jul 18, 2008 at 1:42 PM, Castanaro, Bob <[EMAIL PROTECTED]> wrote: > I believe Delete duplicates will only delete if all the column values are dups. You have to use the delete duplicates using col1 col2 col3, etc to compare just those columns. > It also runs MUCH faster with indexes on those columns, because it has to go through each row individually and compare all these text values. Very time consuming. > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Croson > Sent: Friday, July 18, 2008 2:21 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Interesting behavior > > I'm noticing a bizarre behavior when I issue the DELETE DUPILICATE > with no column references. > > Where there should clearly be a match, the rows are not deleted. Any ideas? > > BTW, I've compared rows of data by hand, and have found duplicate > information in each field, so I know I'm not going batty...YET. > > -- > John Croson > [EMAIL PROTECTED] > http://pcnorb.blogspot.com/ > http://pcnorb.homelinux.org/ > > > -- John Croson [EMAIL PROTECTED] http://pcnorb.blogspot.com/ http://pcnorb.homelinux.org/
