>>>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only