解决方案: |
从模板库(ufmodel)中导入相关记录 请执行如下脚本
DELETE [AA_ColumnSet] where ckey='pu_cgddtocgdhd'
INSERT INTO [AA_ColumnSet]( [cUserId], [cKey], [cFld], [cQryField], [cCaption], [cCaptionPar], [bFixed], [bDisp], [iColWidth], [iAlign], [cOrder], [bLock], [iMergeCols], [bMustSel], [bNeedSum])
SELECT [cUserId], [cKey], [cFld], [cQryField], [cCaption], [cCaptionPar], [bFixed], [bDisp], [iColWidth], [iAlign], [cOrder], [bLock], [iMergeCols], [bMustSel], [bNeedSum]
FROM [ufmodel].[dbo].[AA_ColumnSet]
where ckey='pu_cgddtocgdhd'
DELETE [AA_ColumnDic] where ckey='pu_cgddtocgdhd'
INSERT [AA_ColumnDic]( [cKey], [cFld], [cQryField], [iColPos], [cCaption], [cCaptionPar], [bFixed], [bDisp], [iColWidth], [iAlign], [cOrder], [bLock], [iMergeCols], [bMustSel], [bNeedSum])
SELECT [cKey], [cFld], [cQryField], [iColPos], [cCaption], [cCaptionPar], [bFixed], [bDisp], [iColWidth], [iAlign], [cOrder], [bLock], [iMergeCols], [bMustSel], [bNeedSum]
FROM [ufmodel].[dbo].[AA_ColumnDic]
where ckey='pu_cgddtocgdhd' |