Can i use this query in visual foxpro to get the count.
If the count is greater than one then there is a record with the same values and can show a message duplicate record found.


lcSource = "SELECT count(*) from sub ;
WHERE sub.project_no = projno ;
AND sub.workpkg_no = workpkgno ;
AND sub.sub_sec = subsec ;
AND sub.sub_para = subpar ;
AND sub.sub_seq = subseq ;
AND DELETED() = .f. ;
ORDER BY project_no, workpkg_no ;
into cursor cSource"


Thank you.