>SELECT colltemp.*,COUNT(ctemp_name) AS r_count FROM colltemp ;
> HAVING r_count > 0 GROUP BY ctemp_name INTO CURSOR tmpQuery
>
>Went from VFP6 to VFP9 and now I am getting "Group by clause is invalid or missing"
>
>Anyone know what is wrong?
>
>Brenda

Brenda,
SQL Behavior has been changed since VFP 7, espacialy for GROUP BY cvlause. Now GROUP BY must contain ALL non agragated fields in SELECT clause, to make this SELECT works you must do:

old_seb = SET("ENGINEBEHAVIOR")
SET ENGINEBEHAVIOR 70 && BTW See the help for this command
SELECT colltemp.*,COUNT(ctemp_name) AS r_count FROM colltemp ;
       HAVING r_count > 0 GROUP BY ctemp_name INTO CURSOR tmpQuery
SET ENGINEBEHAVIOR old_seb