解决方案: | 从rpt_glbdef中看到应付明细账中的ID为1957,把两表中原来的id=1957的记录删除,再从正常账套把丢失的纪录粘贴过来。 如008帐套正常,可以用下述语句: select * into tempdb..t_fld from ufdata_008_2005..rpt_flddef where id=1957 select * into tempdb..t_flt from ufdata_008_2005..rpt_fltdef where id=1957 delete from rpt_flddef where id=1957 delete from rpt_fltdef where id=1957 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 tempdb..t_fld insert into rpt_fltdef( [Location], [ID], [Name], [Note], [Expression], [ModeEx], [IsSingle], [Flag], [Caption], [iLeft], [iTop], [iWidth], [iHeight], [iCaptionLeft], [iCaptionWidth], [iPage], [iRefSelect]) select [Location], [ID], [Name], [Note], [Expression], [ModeEx], [IsSingle], [Flag], [Caption], [iLeft], [iTop], [iWidth], [iHeight], [iCaptionLeft], [iCaptionWidth], [iPage], [iRefSelect] from tempdb..t_flt go drop table tempdb..t_fld go drop table tempdb..t_flt |
---|