GROUP BY Clause Problem in VFP8
From: Steve Meyerson (stevemeyerson_at_cox.net)
Date: Sat, 16 Oct 2004 17:53:43 -0400
The following worked fine in VFP6:
SELECT CheckName, Ssn ;
FROM Payroll ;
INTO TABLE TempPay ;
GROUP BY CheckName
In VFP8 I get the error msg:
SQL: GROUP BY clause is missing or invalid
even when I ran it from the command window.
It will work ok if I SELECT only one field instead of 2 or more, but
that's not acceptable.
Payroll is a free dbf. I tried copying Payroll.dbf to "convert" it in
case that was necessary. I also created a simple dbf in VFP8 and got
the same behavior.
Any clue what's going on? Thanks for any help.