In upgrading from 7.0 to 9.0...
I get the following error message from one of my 7.0 apps.

"GROUP BY clause is missing or invalid".

Yet the code (which runs fine on 7.0) definitely has the GROUP BY clause.

SELECT leagex.ex_code,;
STR(sum(leagex.ex_amt),8,2), EX_LIT;
from leagex;
WHERE STR(year(leagex.ex_edate),4) = m.curryear;
group by leagex.ex_code;
into CURSOR totquery4

I don't see anything in the 9.0 documentation about incompatibilities
with the GROUP BY clause.

...could use the help.
Rich Murillo