>>>>>>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')
Erik Moore
Clientelligence