>Dear all,
>
>A table call batch with fields itemcode, batchid, qtynow, qtyatfirst.
>
>I use a local view to sum up the quantity at VFP 6 and have not problem; while at VFP9 it prompt me :
>SQL : group by clause is missing or invalid.
>
>The SQL statment is select itemcode, qtynow, sum(qtynow) as total ;
>where itemcode=?thisform.query group by itemcode order by itemcode
>
>thisform.query is a property I set at the form to holde the specific itemcode I want to check.
>
>
>What is the wrong and how can I solve the problem.

You can additionally Group By qtynow (or Set EngineBehavior 70).



hth
-Stefan