thank you very much.
yes, it works
>>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