标题: accpac 54 AECOM No entry created from AP post [打印本页] 作者: stone 时间: 2013-3-15 15:05 标题: accpac 54 AECOM No entry created from AP post
【Q】accpac 54 AECOM No entry created from AP post
【A】数据库损坏造成多个孤项记录，解决方法是运行下面的查询（在sql management studio或sdk的accpac sql scope中皆可）:
DELETE FROM APPJD WHERE NOT EXISTS (SELECT * FROM APPJH H WHERE H.TYPEBTCH=APPJD.TYPEBTCH AND H.POSTSEQNCE=APPJD.POSTSEQNCE AND H.CNTBTCH=APPJD.CNTBTCH AND H.CNTITEM=APPJD.CNTITEM)
