when i use the followin sql query in my program script i get the above error on compile:
************************************
select whwmd215.item,whwmd215.stoc,sum(whwmd217.mauc(1)):mauc_amnt
from whwmd215,whwmd217
where whwmd215.item = whwmd217.item
and whwmd215.cwar = whwmd217.cwar
and whwmd215.item = :w.item
and whwmd215.cwar = :w.cwar
group by whwmd215.item,whwmd215.stoc

select do
item_mauc = mauc_amnt/whwmd215.stoc
rprt_send()
endselect
******************************************

mauc in table whwmd217 is an array field not sure how to sum the mauc(1) field only. any thoughts would be greatly appreciated

Baazigar:

The use of array fields with functions like sum() in the SELECT clause is not supported until portingset 7.6b. This portingset is currently only available for SSA ERP LN 6.1.

There are plans to migrate SSA BaanERP 5.0c (and newer) installations to portingset 7.6c by the end of 2007, but even then the old application will not use the new SQL processor that was built for SSA ERP LN 6.1.

Therefore the only option that you have is to query for the records that you want to sum up separately and add the array fields up in the SELECTDO.

Yours,
Stephan