Hi Hilmar,

This behavior occurs outside of the main application too. I opened the view through the project manager in the main VFP window, and SET DELETED is OFF. The view works fine with DELETED()=.F., but not with DELETED()=.T., which is what is puzzling me. I even made sure SET DELETED was off, buy running the command in the command window.

I agree about considering deleted records as gone. However, the client has some very odd requirements, which is requiring me to build a somewhat non-traditional solution.

Dave

>Note: Deleted records should normally be considered deleted - gone. Recovering deleted records should be very exceptional.
>
>For your view, try to SET DELETED OFF. If you have SET DELETED ON, the view will only search amongst the non-deleted records.
>
>Note that SET DELETED is scoped to the current datasession. That is, it may be ON in one form, and OFF in another.
>
>>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