Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group By missing or invalid?
Message
From
29/11/2005 14:18:44
 
 
To
29/11/2005 14:10:16
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01072942
Message ID:
01072950
Views:
23
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform