VFP 6 & 8

From: Wilson (wilson_at_sinaisoft.com)
Date: 01/30/05


Date: Sun, 30 Jan 2005 14:16:38 +1100

Friends,

I was using the following query ini VFP 6:

    SELECT lev_name, SUM(leave_acc) ;
    FROM vEmpPayLeaves ;
    GROUP BY leave_code ;
    INTO CURSOR vPaySlipLeaves

After I migrated to VFP8 this query gives error as "SQL: GROUP BY clause is
missing or invalid". But if I exclude lev_name (fields without SUM) it
works.

This query still works in VFP6
My database is Access. I tried to run this query in Access and it works
fine!

Any idea to solve this issue?

Thanks in advance

Wilson