标题：查询

1楼

longyanlin 发表于：2024/12/9 10:18:00

用如下代码查询：1200*2010*18出现错误，请问如改成可以查询带*或者/之类的内容呀，谢谢!

Dim filter As String = "1=2"

For Each dc As Col In Tables("表A").Cols

Filter &= " or Convert(" & dc.Name & ",'System.String') like '%" & e.Form.Controls("TextBox1").Text & "%'"

Tables("表A").Filter = filter

If Filter > "" Then

Tables("表A").Filter = Filter

End If

2楼

有点蓝 发表于：2024/12/9 10:25:00

Filter &= " or Convert(" & dc.Name & ",'System.String') like '%" & e.Form.Controls("TextBox1").Text.replace("*","[*]") & "%'"

3楼

longyanlin 发表于：2024/12/9 11:33:00

谢谢

共3 条记录, 每页显示 10 条, 页签: [1]