Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by clause missing??????
Message
From
08/08/2003 15:00:44
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Group by clause missing??????
Miscellaneous
Thread ID:
00818374
Message ID:
00818374
Views:
51
ok...can someone tell me WHY this gives me "SQL: Group by clause missing or invalid" in VFP8

Sele inv_no, inv_locat, serial_no, sum(cost) as totcost,;
Descrip, budget, user_code, phys_loc, Source, ;
duplicate, loc_name, loc_code;
From shrt1 group by 1 into cursor short2


yet this one doesn't?
SELECT inv_no, sum(cost) as totcost FROM shrt1 GROUP BY 1 INTO CURSOR chkcst


The only difference between the two statements (that I can see) is the field list....
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Next
Reply
Map
View

Click here to load this message in the networking platform