- Foxtable(狐表) (http://foxtable.net/bbs/index.asp)
-- 专家坐堂 (http://foxtable.net/bbs/list.asp?boardid=2)
---- 筛选加条件？ (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=83218)
-- 发布时间：2016/4/3 20:08:00
-- 筛选加条件？
我要在FILTER里面再加一个条件：图片 is not null怎么加入？
Dim txt As String = e.Form.Controls("textbox1").text
Dim tbl As Table = Tables("进货材料_table1")
If txt = "" Then
tbl.Filter = ""
Else
txt = "\'%" & txt & "%\'"
tbl.Filter = "定额编码 like " & txt & " Or 材料名称 Like " & txt & " Or 规格 Like " & txt & " Or 品牌 Like " & txt & " Or 型号 Like " & txt
End If
Dim txt As String = e.Form.Controls("textbox1").text
Dim tbl As Table = Tables("进货材料_table1")
If txt = "" Then
tbl.Filter = ""
Else
txt = "\'%" & txt & "%\'"
tbl.Filter = "定额编码 like " & txt & " Or 材料名称 Like " & txt & " Or 规格 Like " & txt & " Or 品牌 Like " & txt & " Or 型号 Like " & txt
End If
此主题相关图片如下：22.jpg
此主题相关图片如下：22.jpg[此贴子已经被作者于2016/4/3 20:08:07编辑过]
-- 发布时间：2016/4/5 1:21:00
--
tbl.Filter = "(定额编码 like " & txt & " Or 材料名称 Like " & txt & " Or 规格 Like " & txt & " Or 品牌 Like " & txt & " Or 型号 Like " & txt & ") and 图片 is not null"
-- 发布时间：2016/4/5 18:09:00
--
完美，谢谢。