[RBASE-L] - RE: DELETE DUPLICATES, Setting: SET EQNULL OFF

[Buddy Walker]

Fritz

   Delete Duplicates will not compare NULL values. You need to select a
column or columns

 

   DELETE DUPLICATES USI col1, col2 

 

   Do not include the NULL columns.

 

Buddy

 

 

From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Dr. Fritz
Luettgens
Sent: Saturday, December 07, 2013 6:18 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - DELETE DUPLICATES, Setting: SET EQNULL OFF

 

In my table not all colums have values, but duplicates exist.

My standard setting is:                 SET EQNULL OFF, NULL: -0-

I want:                                                 DELETE DUPLICATES
FROM TABLE

result is:                                              0 duplicates have
been deleted

but when:                                          SET EQNULL ON

the command is successful:       n duplicates have been deleted !

Question:           Should this command not also work on a table with
setting SET EQNULL OFF ?

Thank´s

Fritz