这是希望在实现多个关键字查询,关键字是‘蛙服下裤’,‘7018T恤’这样的多个关键字,在sql语句中实现动态加载。
Dim cnm As WinForm.DropDownBox = e.Form.Controls("comname")'定义组合框
Dim str As String = cnm.text '定义组合框字符串内容
Dim ss As String() = str.Split(",")
Dim f As String
For Each t As String In ss
f = f & " or 商品简称 like '%" & t & "%'"
Next
f=f.Remove(0,4)
Dim sql As String = "s*e*l*e*c*t 商品简称,规格名,审核时间,sum(数量) as 数量 from ThrMon where 审核时间 >= '" & Date1 & " 'and 审核时间 <= '" & Date2 & " ' And 商品简称 like '" & f & "'group by 商品简称,规格名,审核时间 "
但是总是提示错误,t变量在一个封闭块中,请问什么地方错了?