>I’m getting:
>
>SQL: Group By clause is missing or invalid
>
>when I try opening views which were OK in VFP7.0 .
>
>Can anyone shed any light on the subject?
GROUP BY has been tightened in VFP8 to be more ANSI SQL compliant. You have to list all (non-agregate) columns:
SELECT Field1, Field2, SUM(Field3) ;
GROUP BY Field1, Field2 ;
INTO CURSOR temp