>>>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.
thanks for everybodies answer - it helped a lot :))