设置会计科目

微信号:yyrjlls
技术咨询,有偿服务!
复制微信号
技术咨询,有偿服务!
复制微信号
原因分析:见答案
问题解答:修改语句。use ufsystemgoupdate GL_CodeClass set cclass = '收入',cclass_engl = 'SR' where (itrade = 34) and inum = 4insert into GL_CodeClass (itrade,inum,cclass,cclass_engl,inumany,nproperty,bl_r,bcheck) values(34,5,'费用','FY',0,1,1,0)goupdate GL_DPrecode set cclass = '收入' , cclass_engl = 'SR' where itrade_id = 34 and cclass = '收入费用'update GL_DPrecode set cclass = '费用',cclass_engl = 'FY' where ccode like '5%' and itrade_id = 34 and cclass = '收入'go