> This thing works fine in VFP 7 when i try to execute it, but in version 9
> it gives me an error GROUP By clause missing or invalid. Anything im
> missing here?
>
> SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as
> tStart, military2 as tEnd,orno as Croom, ;
> cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as
> cdsc,CRANGGRPID as rangegroupid ;
> FROM staffdtl ;
> WHERE staffid = "XXX" ;
> GROUP BY CRANGGRPID ;
> ORDER BY dDateStart, dDateEnd, itimeStart, itimeEnd ;
> INTO CURSOR cTest
>
> TIA!
>
>