Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filter Deleted records in a view
Message
From
30/06/2005 12:05:37
David Villegas
Industrias Del Maíz
Cali, Colombia
 
 
To
30/06/2005 09:05:25
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
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:
01027722
Views:
11
Hilmar thanks for your answer

I don't need to sometimes show records, and sometimes not. Let me explain it to you in other way

The user is creating an order and his respective line items in one form specially designed for this purpose into my application, at this time he needs to delete one or more line items for any reason. when he needs to print the order it prints the line items deleted too. I only need to print only the not deleted line items.

The report to print the order has a view which join all tables needed for this function (orders, order_items, customer, etc). The situation is if I put the condition Deleted() in the fiter property of the view into the report data enviroment, the system filters all order and doesn't print nothing. For these reason i think what the solution is to make the filter in the database when i am creating the view in the view designer, however I don't know how can I do that.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform