>>>>>>>>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?
Erik Moore
Clientelligence