Hi Don,

I suggest you read the Behavior changes since Visual Foxpro 7.0 under What's new in Visual FoxPro 8.0, Language Enhancements. In VFP8 the SQL syntax for GROUP BY was changed in order to ONLY comply with the ANSI standard. A GOOD thing in deed, although it means that if you had old code which did not comply with the ANSI standardm but which was supported by VFP7 and earlier, you must rewrite some of your SELECT statements.

>SELECT inv_mas.inv_no, inv_mas.inv_date, inv_mas.amount, sum(rct_tran.amount) as ytdpaid ;
> FROM aidata!inv_mas inner JOIN aidata!rct_tran ;
> ON Inv_mas.inv_no = Rct_tran.inv_no ;
> GROUP BY 1;
> INTO DBF cInv
>
>The above SQL command is perfectly working in VFP6. But when I tried it in VFP8 it gives me the following error message.
>
> SQL: GROUP BY clause is missing or invalid.
>
>Can anyone help me please?
>
>Don