阅读:2568
回复:7
|
[BUG反馈]错误:方法"123"的设置不是XML
怎么我集成业务方法的时候一直提示“错误:方法"123"的设置不是XML” 但是我在数据库中都能执行 这个找不到问题所在的呢 就是最后一个where条件 加上就不能通过 删除就通过了 怎么回事呢
select c.cCusCode,c.cCusName,cf.cCusName KHZGS,c.cCusBP, ISNULL(wkps.wkp,0) wkp,ISNULL(ykp.md,0) md,ye.ysye,ykpye.ykpye, kp.InvoiceType,kp.OpenUnit,kp.RegAddr,kp.RegPhone,kp.Bank,kp.BankAccount,kp.TaxPayerID from UFDATA_010_2012.dbo.Customer c left join UFDATA_010_2012.dbo.Customer cf on cf.cCusCode=c.cCusHeadCode left join ( select SUM(md)-SUM(mc) wkp,ccus_id from UFDATA_010_2012.dbo.GL_accvouch where ccode='112202' group by ccus_id ) wkps on wkps.ccus_id=c.cCusCode left join ( select sum(md) md,ccus_id from UFDATA_010_2012.dbo.GL_accvouch where ccode='112201' group by ccus_id ) ykp on ykp.ccus_id=c.cCusCode left join ( select sum(mc)-sum(md) ykpye,ccus_id from UFDATA_010_2012.dbo.GL_accvouch where ccode='112201' group by ccus_id ) ykpye on ykpye.ccus_id=c.cCusCode left join UFDATA_010_2012.dbo.BPM_YSYE ye on c.cCusCode=ye.cDwCode left join ( select a.CusCode, a.CusName, a.OpenUnit, a.TaxPayerID, a.RegAddr, a.RegPhone, a.Bank, a.BankAccount, a.InvoiceType from H3Cloud.dbo.i_CustomerOpenInvoice_SCJC as a join H3Cloud.dbo.OT_InstanceContext b on a.ObjectId=b.BizObjectId and b.State ='4' ) kp on kp.CusCode=c.cCusCode where ye.ysye < 0 and ISNULL(wkps.wkp,0) <= 0 and ykpye.ykpye >0 |
2楼#
发布于:2017-05-15 13:46
这的确算是一个bug。@H3产品支持_开心
|
|
|
3楼#
发布于:2017-05-16 13:59
请问您用的BPM,是哪个版本呢?
|
|
|
5楼#
发布于:2017-05-16 19:49
|
|
|
6楼#
发布于:2017-05-17 09:33
已将您的问题反馈给产品中心~
|
|
|
7楼#
发布于:2017-05-19 11:45
xml中的特殊字符,处理方式:
<![CDATA[ sql语句 ]]> 如: <![CDATA[ SELECT ISNULL((SELECT Price FROM [dbo].[Material] WHERE 1<>2 AND Code=@Code),100) as Price]]> |
|