Invalid Group By

Author: jerry foote

Posted: 2014-01-03 at 19:49:43

"LOOK_ACCT=127

select

MANI_ID,MANIFEST_N,BILL_OF_LA,transfers,transfr_no,to_acct,SUM(TOTAL_UNIT)

AS TOTAL_UNIT, ;

SUM(RELEASED) AS RELEASED,0000000 as releacnt ,00000000 AS SUMTRANS, 000000

AS SUB_BALANCE ,000000 AS BALACEIS;

FROM transfers where to_acct=LOOK_ACCT .AND. TRANSFERS>0 AND

FROMSOURCE="TRANSFER";

INTO CURSOR selected1 READWRITE GROUP BY mani_id"

When I execute the above code I get error "SQL: GROUP BY clause is missing

or invalid.",even when I leave the group by off I get same error.

Any help as to what is wrong would be appreciated.

Thanks Jerry

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/98F0C5EB42D447A9AC1D5ABEA2F58F1B@jerryfootePC

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2014 jerry foote