本篇文章主要介绍了"FRM-30377: Summary item must reside in single-record block or in same block as summarized item.",主要涉及到FRM-30377: Summary item must reside in single-record block or in same block as summarized item.方面的内容,对于FRM-30377: Summary item must reside in single-record block or in same block as summarized item.感兴趣的同学可以参考一下。
解决: 汇总的Item需要单独放在一个Block里面,不要与需要汇总的Item放在一个Block里面
例如:需要汇总的ITEM在块 XXX_LINES BLOCK块中
汇总的ITEM在 XXX_SUMMARY BLOCK中;
其中:XXX_LINES的SINGLE RECORD 需要设置为NO
XXX_SUMMARY的SINGLE RECORD 需要设置为YES 这样就不会报上述错误。
但是这个时候编译还是可能报下面错误: FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes. Item: REQ_QTY Block: CALCULATE FRM-30085: Unable to adjust form for output.
解决: XXX_LINES的Query All Records 设置为YES