>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.

You might change deleted() = .F. to not deleted().

Better yet:

SET DELETED ON

Then you won't need the "not deleted()" in the SQL query.

Hilmar.