A dupecount query:

select <fldname> as <fldname>, count(<fldname>);
  from <fromtable>;
  group by <fldname>;
  having count(<fldname>)>1;
  into cursor CurDupeCounts

>I get the same error from VFP. By the way I have version 7. How do I know if I have data corruption? I have aover 5 million records. How do you remove duplicates or create a unique query with sql select?
>
>Thanks