Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change in SQL commands!
Message
From
13/09/2004 23:10:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Title:
Change in SQL commands!
Miscellaneous
Thread ID:
00941771
Message ID:
00941771
Views:
67
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
Next
Reply
Map
View

Click here to load this message in the networking platform