如何删除客户父级分类001？-用友T3

如何删除客户父级分类001？

微信号：yyrjlls
技术咨询，有偿服务！
复制微信号

原因分析：（客户分类级别 *** *** ***） 删除父级001分类delete CustomerClass where ccccode = 001 insert into CustomerClass(ccccode,cccname,iccgrade,bccend) select substring(ccccode,4,3) as ccccode,cccname,iccgrade-1 as iccgrade,bccend from CustomerClass where ccccode like '001%'update customer set ccccode = substring(ccccode,4,3) where ccccode like '001%'delete CustomerClass where ccccode like '001%'

问题解答：（客户分类级别 *** *** ***） 删除父级001分类delete CustomerClass where ccccode = 001 insert into CustomerClass(ccccode,cccname,iccgrade,bccend) select substring(ccccode,4,3) as ccccode,cccname,iccgrade-1 as iccgrade,bccend from CustomerClass where ccccode like '001%'update customer set ccccode = substring(ccccode,4,3) where ccccode like '001%'delete CustomerClass where ccccode like '001%'

本文链接：https://www.bbsufida.com/t3/26111.html