Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter Deleted records in a view
Message
From
30/06/2005 08:57:50
David Villegas
Industrias Del Maíz
Cali, Colombia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01027010
Message ID:
01027636
Views:
12
Hi Mr Bereznikler

Thanks for your answer Set deleted ON really works on views, but my issue is a little diferent and I will try to explain you.

I have 2 tables Orders and Order_items with them and others I manage the Ordering process in my application. However the user can delete one or more items of the order, in the form I use set deleted on to filter and works ok. In order to print the order document I use a local view to join all needed fields but if I use Deleted() in the view property it filter the deleted order items and his respective parents too. I only need to filter the records marked in the order_items.

May be the solution is in the filter conditions of the view designer, but i don't know how to do.

You can help me please

Regards
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform