>>>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.

Here's the event firing sequence from the VFP 6.0 help file:

Object Events
Form set Load
Data environment BeforeOpenTables
Form(s) Load
Data environment cursor(s) Init
Data environment Init
Objects 1 Init
Form set ReadWhen
Form set ReadActivate
Form set ReadShow
Form set Show
Form Show
Form set Activate
Form Activate
Object 2 When
Form GotFocus
Object 3 GotFocus
Object 4 Valid


1 For each object, from innermost object to outermost container

2 The first object in the tab order

3 If the When event returned true (.T.)