>>>>>>>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.
>
>CURSORSETPROP('buffering',1,'mytable')
>SELECT blah blah blah
>CURSORSETPROP('buffering',5,'mytable')

Will the buffered records get written back to disk this way? I thought SELECT always gets data from disk. It wouln't get data from memory.

I am confused. Can you elaborate?