>hi all,
>any idea,help
>this code work fine without field name is tra (memo type),
>i got error message GROUP BY clause is missing or invalid
>
>
>LOCAL ldStart
>ldStart = thisform.text1.value
>SELECT nam,amount,bank,sheqno,dat,tra, SUM(amount) AS bill_total FROM Mstr ;
>WHERE dat= ldStart ;
>GROUP BY nam,amount,bank,sheqno,dat,tra ;
>ORDER BY sheqno INTO CURSOR qTmp
>
>thanks
You can not include memo field. If you want to use memo field you would need to run with SET ENGINEBEHAVIOR 70.
See
Re: GROUP BY clause is invalid Thread #
1245947 Message #
1245974
If it's not broken, fix it until it is.
My Blog