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