专家坐堂-Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  当前表模糊筛选  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=170807)

--  作者：有点蓝
--  发布时间：2021/8/8 20:28:00
--

Else
txt = "\'%" & txt & "%\'"
dim f as string = "1=2"
for each c as col in tbl.cols
if c.IsString then
f = f & " or " & c.name & " Like " & txt
end if
next
  tbl.DataTable.loadFilter = f
tbl.DataTable.load
End If

--  作者：有点蓝
--  发布时间：2021/8/9 22:50:00
--

Dim f As String = "1=2"
For Each c As Col In tbl.cols
If c.IsString Then
f = f & " or " & c.name & " Like " & txt
End If
Next
f = "(" & f & ") and 权限组 Like \'%" & User.Name & "%\'"
tbl.DataTable.loadFilter = f
tbl.DataTable.load