Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Group By missing or invalid?
Message
De
29/11/2005 14:18:44
 
 
À
29/11/2005 14:10:16
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 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01072942
Message ID:
01072950
Vues:
22
>Because of MAX()
>Aggregate functions require grouping. Would not make sense otherwise (ANSI).
>
>Also, returning ALLTRIM(trackrcd.t_s_num) may give you incomplete results as VFP will return a field length based on the length of the first item found. Try PADding it or in VFP9 using CAST().

Thank you for the great explaination.

< crying > but it worked in Vfp6 ;-)

I can probable take that alltrim off, but not the others, because the variables on thisform are already alltrimed, and if not kept the same, will not work.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform