我在按钮的事件里面添加了点击事件,有三个参数,js代码是:
var sql="exec sp_rms_select_0460 "+FUNDCODE+","+DATE+","+STATUS;
var res=FR.remoteEvaluate('sql("dbbasedata","'+sql+'",1,1)');
FR.Msg.toast(res),
点击了以后没有反应,这是为什么呢?
92259
CASE WHEN ((c_custname not like '%中信建投%') and custtype = '0') THEN '机构'
WHEN ((c_custname not like '%招商证券%') and custtype = '0') THEN '机构'
WHEN ((c_custname not like '%申万宏源%') and custtype = '0') THEN '机构'
when ((c_custname like '%中信建投%') and custtype = '0') then '做市商'
when ((c_custname like '%招商证券%') and custtype = '0') then '做市商'
when ((c_custname like '%申万宏源%') and custtype = '0') then '做市商'
else '个人' end as c_custtype
请大神帮我看看为什么我这个语句不起作用,只要custtype = 0的情况都是显示为机构,当c_custname符合后面条件的而且custtype = 0的时候值不为‘做市商’,这是为什么呢?