>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
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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.