用友U8清除账套锁定及系统锁定的SQL语句

用友U8清除账套锁定及系统锁定的SQL语句

用友知识库用友软件2018-10-04 18:52:149420A+A-

问题现象:用友U8清除账套锁定及系统锁定的SQL语句 ?

use ufdata_XXX_2014 --xxx表示账套号2014表示年度

delete from gl_mccontrol

微信号:yyrjlls
扫码 有偿解决 用友软件技术问题!
复制微信号

delete from gl_mvocontrol

delete from gl_mvcontrol

delete from ap_lock

delete from lockvouch

delete from ia_pzmutex

delete from gl_lockrows

---清除ufsystem 里的任务

use ufsystem

delete from ua_task

delete from ua_tasklog

点击这里复制本文地址 以上内容由用友财务软件免费试用版下载整理呈现,请务必在转载分享时注明本文地址!如对内容有疑问,请联系我们,谢谢!

支持Ctrl+Enter提交

用友财务软件免费试用版下载 © All Rights Reserved.  

copyright © 2011-2025 new.aiufida.com .