Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using a HAVING in view builder
Message
De
25/03/2003 14:31:54
Gary Foster
Pointsource Consulting LLC
Chanhassen, Minnesota, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Using a HAVING in view builder
Divers
Thread ID:
00769877
Message ID:
00769877
Vues:
47
Hi all,
I seem to be missing something when trying to use the view builder. Here is what I want to add to a SELECT to show a customer with 3 or more records in the customer table:

GROUP by customer_id HAVING count(*) > 2

The view builder's "having" builder allows me to enter the "count(*)" in the field name expression, the ">" in the comparison field and the "2" in the example field. It just won't allow me to save. Any suggestions?

Gary Foster
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform