Bob,
Right on! set eqnull on and delete duplicates worked.
thanks for your input.
Bernie Lis
----- Original Message -----
From: "Thompson Technology Consultants" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[email protected]>
Sent: Friday, October 14, 2005 9:56 PM
Subject: [RBG7-L] - RE: delete duplicates
Check your EQ NULL and zero settings. I believe that
Null does not equal Null under normal circumstances,
so Rbase would not consider a record a duplicate if it
contained any null field values.
If you records do not contain any null fields, then you
might try rebuilding your indexes just in case something
is amiss there.
-Bob
Thompson Technology Consultants
276 Chippewa
LaPorte, IN 46350
219-324-2605 (Phone & Fax)
219-363-7441 (Cell)
http://ttc.inc.home.comcast.net
-----Original Message-----
From: Bernard Lis [SMTP:[EMAIL PROTECTED]
Sent: Friday, October 14, 2005 6:51 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - delete duplicates
I have a table called chemtabl
I did: delete duplicates from chemtabl and got 0 rows deleted.
I know I have at least 14 rows that are exact duplicates because I
projected
those rows to another table and then inserted them back into chemtabl.
I do not want to specify column names because I want to make sure that
they
are exact dups.
Bernie Lis
