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