用友T6软件如何删除客户父级分类001？-用友T6

用友T6软件如何删除客户父级分类001？

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

如何删除客户父级分类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%'

问题解答：（客户分类级别 *** *** ***） 删除父级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%'

如果您的问题还没有解决，或者在百度上找不到答案可以到右上角搜索中进行搜索。

本文链接：http://www.bbsufida.com/t6/32652.html