Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GROUP BY Clause problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01058109
Message ID:
01058153
Views:
13
>What about the rest of the GROUP BY Clause? VFP 9.0 requires everything except for the aggregate functions, right? I will make the change and use the parens.
>
>Thanks,
>
>Cecil
>
>>You can't GROUP BY an expression (LOADING.Order + LOADING.Line).

You still can't group by an expression at all. You'll have to include the expression as a new field, and then use that name or the ordinal field position number.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform