>Hi Friends!
>
>How can I delete all duplicate records from a table?
>
>TIA
Typically you may issue SQL statement like this:
SELECT myfieldname, COUNT(myfieldname) ;
FROM mytable ;
GROUP BY myfieldname ;
HAVING COUNT(myfieldname) > 1 ;
INTO CURSOR mycursor
You might try also some utilities in Download section:
file#289
file#
9631
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison