| 解决方案： |
因为RPT_FLD表有丢失的记录,正好是系统要求必须选的系统标志,单据号,处理号,从正常数据库中把丢失的记录补上就可以解决了.
Select * into tmp_ap
From ufdata_001_2004..Rpt_FldDEF
Where ModeEx=3
and ID = 1954
and name not in
Select name From ufdata_188_2004..Rpt_FldDEF
Where ModeEx=3 and ID = 1894
go
update tmp_ap set id=1894
go
insert into Rpt_FldDEF ID,Name,Expression,Condition,ModeEx,OrderEx,TopEx,LeftEx,Width,Height,Visible,
Note,nameForeign,iColSize,FormatEx,iAlignStyle,iSize
select ID,Name,Expression,Condition,ModeEx,OrderEx,TopEx,LeftEx,Width,Height,Visible,
Note,nameForeign,iColSize,FormatEx,iAlignStyle,iSize from tmp_ap
go
drop table tmp_ap |