>Hi all
>
>I looking for some way to detect in a table (using a query) in VFP 3.0
>how to detect duplicate records..
>
>Thanks in advance
Determine what makes a record unique, say field1, field2, field3, then:
SELECT field1, field2, field3, count(*) as count ;
from MyTable ;
group by field1, field2, field3 ;
having count > 1 ;
into cursor cdupes
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer