>>>I just discovered that my views do not respect "set deleted". How can I use the view designer to ignore deleted records?
>>>
>>>TIA
>>
>>
>>SET DELETED is scoped to the data session. If you are using Private data sessions, you need to do a SET DELETED in the Form.Load.
>
>I have "set deleted on" in my frmBase.Load but any views in the DataEnvironment that have "NoDataOnLoad"=.F. still have deleted records in them.
>I have stepped through the process, and the views are opened before the Load method is executed.
>Is there some way to catch them prior to opening? Or is my only choice to set "NoDataOnLoad" for all cursors, and requery() them once the form is loaded? I really don't want to have to remember to put "set deleted on" in each BeforeOpenTableEvents of each form.
In the filter tab of your view add a criteria "expression" DELETED()=.f.