解決辦法:清理異常、清除站點;如果都不行,數據庫清理鎖定:
delete from cn_lockacctbook where cAuth<>'刪除'---(根據條件刪除)
解決辦法:清理異常、清除站點;如果都不行,數據庫清理鎖定:
update gl_accvouchset ssxznum= NULL,BDELETE=0,wllqPeriod=NULL,wllqDate=NULL,iflagperson=NULLwhere iperiod=憑證所在的期間and ssxznum=(select ssxznum from gl_accvouch where iperiod=憑證所在的期間 and INO_ID=要刪除憑證的憑證號 AND CCODE =in(要刪除憑證中的應收科目) (‘66010405’,‘10020302’)
select VoucherStr,VouchOutSignNum,* from CN_AcctBook VouchOutSignNum 將此字段的值改為NULL即可。CN_AcctBook 出納日記賬update CN_AcctBook set VoucherStr='記 1' , VoucherNum='1' , IsRegGLVouch='1' , vouchoutSignNum='SC1000000578'where acctDate='2015-02-02 00:00:00.000' and ID='2575'
delete from ufdata_003_2015..gl_mccontrol;
delete from ufdata_003_2015..gl_mvocontrol;
delete from ufdata_003_2015..gl_mvcontrol;
delete from ufsystem..ua_task;
delete from ufsystem..ua_tasklog;
delete from ap_lock ----------應收應付鎖定控制表
delete from GL_MCCONTROL -------總賬科目控制表
delete from lockvouch------------客戶供應商控制表
--清除-CM_Tasklog-和CM_Task-兩個表
select * from CM_Tasklogselect * from CM_Task(這個表一般沒有數據)
delete from CM_Tasklog
銷售熱線:0451-86626069 |
服務熱線:0451-88191988 |
QQ號:2448959464 |
(微信掃一掃)