Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleted records in views
Message
De
29/07/1998 23:39:50
 
 
À
29/07/1998 12:49:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00122160
Message ID:
00122585
Vues:
17
>>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform