Group By in VFP8 has changed. It must now match the fields in the select (except for aggregate fields).

Alan

>Hi All:
>
>The following works in VFP 7 but not in 8. What am I doing wrong?
>
>

>cflcode = 'GEG12031'
>SELE flckmast.fm_flcode, grower.gr_shdesc,  ;
>	flckmast.fm_hatched, SUM(hatcinfo.hi_amt)  ;
>	FROM grower ;
>	inner JOIN flckmast ;
>	ON grower.gr_grcode = flckmast.fm_grcode ;
>	inner JOIN hatcinfo ;
>	ON hatcinfo.hi_flcode = flckmast.fm_flcode ;
>	WHERE !EMPTY(flckmast.fm_cycle)  ;
>	AND flckmast.fm_flcode  = cflcode ;
>	GROUP BY hatcinfo.hi_flcode  ;
>	ORDER BY flckmast.fm_farmdlv ;
>	INTO CURSOR "Z" + SUBSTR(SYS(2015) ,3,10)
>

>
>The error message is:
>
>

>SQL: GROUP BY clause is missing or invalid
>

>
>Thanx -
>
>Yossi