>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