Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleted records in views
Message
From
29/07/1998 23:39:50
 
 
To
29/07/1998 12:49:53
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00122160
Message ID:
00122585
Views:
18
>>>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.
System Analyst
Nabil B. Ghrayyeb
nabilg@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform