Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Deleted
Message
From
22/07/2001 19:01:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Set Deleted
Miscellaneous
Thread ID:
00533709
Message ID:
00533709
Views:
33
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
Next
Reply
Map
View

Click here to load this message in the networking platform