Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to show deleted records in a view
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00234771
Message ID:
00234796
Views:
24
>Is there a good way of showing deleted records in a view? I want to select all records for a specified date, deleted or not. But, I do want the deleted records to display the deletion mark in the grid.
>
>Does this require some post processing after the view does it's querying, or is there some simple flag that I've overlooked on the view setup?
>
>Thanks!

This is a problem with views. A workaround is to include Deleted() as DelFlag in the query's Select field list. Then, if you want, after you open the view, issue the following command:

delete for delflag
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform