>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,
RTFM. Look at the What's New section of the VFP help file for both VFP 8 and 9.
Take a look at Message #
974233
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst