>>>>>>>>>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?
>
>Is there a reason that you don't want to commit changes before doing a count?

Because it is part of a transaction. The user has a choice of reverting the all the changes he has made during the transaction.