以文本方式查看主题 - Foxtable(狐表) (http://www.foxtable.com/bbs/index.asp) -- 专家坐堂 (http://www.foxtable.com/bbs/list.asp?boardid=2) ---- [求助]分页加载之后台筛选无效 (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=153497) |
-- 作者:crazyfengyu -- 发布时间:2020/8/13 11:05:00 -- [求助]分页加载之后台筛选无效 With
DataTables("日志") If .LoadPage <> 0 Then .LoadTop = 20 .LoadPage = 0 .Load() End If End With 使用上面的代码进行分页加载,分页加载实现了,开启了表的后台筛选,但是使用下面代码过滤还是只能筛选当前页数据,没有筛选后台其他数据 dim txt as winform.textbox = e.form.controls("筛选") dim t as table = tables("日志") If txt = "" Then t.Filter = "" Else Dim str As String = txt Dim filter As String filter = "1=1" Dim nms() As String = {"用户","涉及表","涉及列","涉及行","操作","原始数据","类型"} For Each s As String In str.Split(",") s = s.Replace("%","[%]") s = s.Replace("*","[*]") s = "\'%" & s & "%\'" Dim f As String = "" For Each nm As String In nms f &= " or " & nm & " like " & s Next filter &= " and (" & f.SubString(4) & ")" Next t.Filter = filter End If |
-- 作者:有点蓝 -- 发布时间:2020/8/13 11:34:00 -- 筛选本来就是只能针对已经加载的数据。 开启了表的后台筛选仅支持内置的筛选树
|
-- 作者:crazyfengyu -- 发布时间:2020/8/13 13:07:00 -- 有没有办法这个筛选也可以筛选后台的? |
-- 作者:有点蓝 -- 发布时间:2020/8/13 13:32:00 -- 没有,请改为加载的用法。筛选后台实际上就是重新加载数据 |