Never mind,
I found the problem. :)
Philip
PLB wrote:
> Can anyone suggest why I 'd be getting the following error in the
> following SQL Statement (VFP 8.0)
>
> Error: SQL: Group by clause is missing or invalid.
>
> SELECT INVDTE , ;
> INVNO, ;
> gLASST, ;
> ARSTAT,;
> IIF(ARSTAT = "V",(0* extweight),SUM(extweight)) AS ntotweight;
> FROM (gcarpath + "ARTRAN" + gcCompID) ;
> HAVING BETWEEN(INVDTE,dBeginDate,dEndDate) ;
> INTO DBF (gcdatpath + 'tmpdata') ;
> GROUP BY INVDTE, INVNO, gLASST ;
> ORDER BY INVDTE, INVNO, gLASST
>
>
> Thanks,
>
> Philip
>
>
[excessive quoting removed by server]
©2004 PLB |
