Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Group by
Message
De
04/01/2005 18:07:41
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
00974218
Message ID:
00974230
Vues:
24
Hi Geoff.

If you want the query to work in versions later than 7 without setting "backward compatible" on, ammend your query as follows:
SELECT cnt(wo_itemno) as items, i_key, t_key, contractor ;
  FROM v_woitems ;
  INTO CURSOR tWoinvcont ;
  ORDER BY t_key ;
  GROUP BY t_key, i_key, contractor
All of the items in the SELECT statement except for the fields being aggregated need to be in the group by clause.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform