Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Filter Deleted records in a view
Message
De
30/06/2005 12:05:37
David Villegas
Industrias Del Maíz
Cali, Colombie
 
 
À
30/06/2005 09:05:25
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01027010
Message ID:
01027722
Vues:
12
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform