BIM建模工具菜单项无法显示解决办法
yangyang0283
3,624次浏览
编辑于2014年02月27日 09:44:32
BIM建模工具中,数据库中如出现脏数据,会导致主菜单中,菜单项为空,无法显示菜单内容(如图）,此时需执行以下脚本来处理
update t_pm_mainmenuitem mm set flevel = (select flevel from t_bas_sysmenuitem sm where sm.flevel is not null and sm.flongnumber = mm.flongnumber) where flevel is null and exists(select * from t_bas_sysmenuitem sm where sm.flevel is not null and sm.flongnumber = mm.flongnumber)
delete from T_PM_MainMenuItem where flevel is null
update t_pm_mainmenuitem mm set flevel = (select flevel from t_bas_sysmenuitem sm where sm.flevel is not null and sm.flongnumber = mm.flongnumber) where flevel is null and exists(select * from t_bas_sysmenuitem sm where sm.flevel is not null and sm.flongnumber = mm.flongnumber)
delete from T_PM_MainMenuItem where flevel is null
7.jpg(29.85KB)
推荐阅读