问题现象:清空年度账时提示已经有客户使用[333]账套[2009],年度账,不能清除!
解决方案:经查看没有操作使用也没有任务或锁定信息,可通过在数据库中删除年度账来重新建立来操作。
以333账套删除2009年度账为例,SQL语句:
use UFSystem
delete from UA_Account_sub where cAcc_Id=333 and iYear=2009
delete from UA_BackupLog where cAcc_Id=333 and iYear=2009
delete from UA_BackupPlans where cAcc_Id=333 and iYear=2009
delete from UA_HoldAuth where cAcc_Id=333 and iYear=2009
delete from UA_Log where cAcc_Id=333 and iyear=2009
delete from UA_Period where cAcc_Id=333 and iYear=2009
delete from UA_Task where cAcc_Id=333 and iYear=2009
Drop database ufdata_333_2009