>>I want the count of the table to return empty even if it has
>>records mark as deleted. reccount() ignores set dele on.
>>any ideas?
>
>How about COUNT FOR NOT DELETED() TO lnRecCount?

COUNT will move the cursor to the end of the table.
If you don't want he cursor to move, you could use also:

SELECT Count(*) FROM MyTable WHERE Deleted() = .F.