Before you can fix it, you should understand why you're getting the error. See Re: Change in SQL commands! Thread #941771 Message #941774

>
>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.
>
>
>
>Regards,
>
>Ransome