>>>>>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.
>>
>>Take note that SELECT will not work for tables on table-buffering mode.
>
>True, but you can set buffering off, SELECT, then on again...

You are not saying the records in the buffer can be SELECTed, right? I will be very happy if I can get all the records, including those in the buffer, using SELECT statement. I have been using commands like COPY TO before SELECT in order to get those records in the buffer.