赛捷软件论坛's Archiver

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)

页: [1]

Powered by Discuz! Archiver 7.2  © 2001-2009 Comsenz Inc.