[求助]模糊查找,Like触发错误 Post By:2020/8/1 9:24:00 [显示全部帖子]
请问老师,这段如何修改,可以查询有符号的,比如*,“”类的
Dim txt As String = e.Form.Controls("TextBox1").Text
Dim tbl As Table = Tables("库存")
If txt = "" Then
tbl.Filter = ""
Else
txt = "'%" & txt & "%'"
tbl.Filter = "规格名称 Like " & txt & " Or 件号图号 Like " & txt & " Or 材质 Like " & txt & " Or 备注 Like " & txt & " Or 物料编码 Like " & txt & " Or 库存编码 Like " & txt