The data environment opens the tables before the Load() executes. By that time the views already have the deleted records in them.


>You should SET DELETED ON in the Load() Event of every form.
>
>This is most conveniently declared in your base classes (any change, correction, amplification you do there propagates to every form).
>
>Hilmar.
>
>>I'm using VFP 5.0a
>>I just discovered that "Set Deleted" is scoped to the current data session (I never deleted records before now). And it defaults to "OFF".
>>
>>How can I put a view into the data environment of a form with a private data session, so that it will not include deleted records from the underlying table? The data environment opens all the tables before I can "set deleted on". It doesn't even mark the records deleted that have been deleted in the underlying tables.
>>
>>Or even more important:
>>How can I put a Private Data Session on a report that uses a view in it's data environment?
>>I have several views that have an "or" in the filter and I can't find a way to put in an "and !deleted" into the filter. The only choice I have found is to not put a Private Data Session on the report, so it uses the "set Deleted" from the form's data session.
>>
>>TIA