select t1.requestid,t1.sqrq,t1.zxrq,REPLACE(REPLACE(convert(varchar(1000),t1.bz1),' ',''),'<br>','')as bz,t1.wlbmdk,t1.wlbmkh,t1.cpxh,t1.dsmc,t1.dsjg,b1.operator,
REPLACE(REPLACE(REPLACE(REPLACE(convert(varchar(1000),b1.remark ),'<p>',''),'</p>',''),' ',''),'<br>','')as remark
from [dbo].[workflow_requestlog_jgsq_view] b1,[dbo].[formtable_main_77_view] t1
where t1.requestid=b1.requestid {IIF(@物料编码大库 = "", "", " and wlbmdk='" & @物料编码大库 & "'")}
在这里面我需要写个明细字段作为查询条件,这查询参数写上就报错,这是那块有问题?
|
|