cloud7.1 下载数据,提示结算方式重复

栏目:云星空知识作者:金蝶来源:金蝶云社区发布:2024-09-23浏览:1

 cloud7.1 下载数据,提示结算方式重复

问题描述:

cloud7.1 下载数据,提示结算方式重复

解决方案:

cloud数据库执行脚本文件:

select * from T_META_FORMENUMITEM where FID='8c4ceb92-08d3-47d5-8f04-0e20df4fc769' and FVALUE = '20'
select * from T_META_FORMENUMITEM_L where FENUMID = 'bc65eaf8-beb7-4d83-8534-30b1a3ca5752'

delete from T_META_FORMENUMITEM_L where FENUMID = (SELECT a.FENUMID   
 FROM T_META_FORMENUMITEM  a INNER JOIN T_META_FORMENUMITEM_l al on a.FEnumID=al.FEnumID   
 WHERE a.FID='8c4ceb92-08d3-47d5-8f04-0e20df4fc769' AND  al.FLOCALEID = 2052
 and a.FVALUE = '20' and al.FCAPTION = '订金')

delete from T_META_FORMENUMITEM where FENUMID = (SELECT a.FENUMID   
 FROM T_META_FORMENUMITEM a  WHERE a.FID='8c4ceb92-08d3-47d5-8f04-0e20df4fc769'
 and a.FVALUE = '20' and a.FENUMID = 'bc65eaf8-beb7-4d83-8534-30b1a3ca5752')

cloud7.1 下载数据,提示结算方式重复

问题描述:cloud7.1 下载数据,提示结算方式重复解决方案:cloud数据库执行脚本文件:select * from T_META_FORMENUMITEM where FID=...
点击下载文档
确认删除?
回到顶部
客服QQ
  • 客服QQ点击这里给我发消息