>How can I scan a table and find duplicate values in a particular field? I want to create a primary index on two fields and it tells me it can't be done because of dups.
Assuming the 2 fields are
Field1
and
Field2
:
Select Field1, Field2, Count(*) ;
From mytable ;
Group By Field1, Field2 ;
Having Count(*) > 1 ;
Into Cursor cuDupes
Insanity: Doing the same thing over and over and expecting different results.