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.



Regards,

Ransome