Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Group by
Message
From
04/01/2005 18:07:41
 
 
To
04/01/2005 17:50:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
00974218
Message ID:
00974230
Views:
22
Hi Geoff.

If you want the query to work in versions later than 7 without setting "backward compatible" on, ammend your query as follows:
SELECT cnt(wo_itemno) as items, i_key, t_key, contractor ;
  FROM v_woitems ;
  INTO CURSOR tWoinvcont ;
  ORDER BY t_key ;
  GROUP BY t_key, i_key, contractor
All of the items in the SELECT statement except for the fields being aggregated need to be in the group by clause.
Previous
Reply
Map
View

Click here to load this message in the networking platform