When you select deleted records from a table into a view, the delete mark will not be black no matter what you do.

Modify your SQL for the query to look like:

SELECT FieldListHere, DELETED() as IsDeleted FROM MyTable WHERE ...

Now you have a logical field in the cursor named IsDeleted.

>Hi,
>
>I've built a view for the purpose of displaying deleted records only. I set the view filter to Deleted()=.T.
>
>However, when I run the view, it shows no records at all. I created the exact same view with Deleted()=.F. to only show records not set for deletion, and that works fine. It is only the Deleted()=.T. that does not work.
>
>I also ran the same view without any kind of filter, and it shows all records, including the records set for deletion. However, the deletion marks are not visible with the records that are marked for deletion in the source table. The deletion marks are visible in the source table, but not in the view. I don't understand what is going on here. Set Deleted is turned off, which means this could not be a factor.
>
>Any help would be appreciated.
>
>Dave