Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Change in SQL commands!
Message
De
13/09/2004 23:10:16
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Titre:
Change in SQL commands!
Divers
Thread ID:
00941771
Message ID:
00941771
Vues:
66
In VFP7 this commend work:

SELECT MAX(nJN2_1) as MaxTime, cJN2_2 from jn2

In this command I can see Max of nJN2_1 and cJN2_2 that have Max Value.
In VFP8 and VF9 when I run this command see an error:

SQL: GROUP BY Clause is missing or invalid.

Why? and if this command is changed, how we can know what record have Max Value!
Saed
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform