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

Foxtable(狐表) → 用户栏目 → 专家坐堂 → 查询表加载条件放在beforeloadoutertable中错误

共有3448人关注过本帖树形打印复制链接主题：查询表加载条件放在beforeloadoutertable中错误

kao_go

小大 1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC

加好友

发短信

等级：二尾狐帖子：562 积分：4845 威望：0 精华：0 注册：2014/4/29 14:32:00

查询表加载条件放在beforeloadoutertable中错误 发帖心情

Post By：2015/2/5 11:52:00 [只看该作者]

http://www.foxtable.com/help/index.html?n=2751.htm

我按照这个帮助里面，设置动态加载表的加载条件，查询表会提示错误

Bin

小大 2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC

加好友

发短信

等级：贵宾帖子：35433 积分：178524 威望：0 精华：3 注册：2013/3/30 16:36:00

Post By：2015/2/5 11:52:00 [只看该作者]

你条件没设置对. 条件发出来我看看

kao_go

小大 3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC

加好友

发短信

等级：二尾狐帖子：562 积分：4845 威望：0 精华：0 注册：2014/4/29 14:32:00

Post By：2015/2/5 11:56:00 [只看该作者]

Select Case e.DataTableName
    Case "shouye","biaoti","ftp","caozuo","danju","djbh", _
        "ywy","danwei", _
        "yangpin","yangpinggmx", _
        "shangpin","yanse","chima","spsx1","spsx2","spsx3","spsx4","spsx5","spsx6", _
        "wlcf","wldalei","wlsx1","wlsx2","wlsx3","wlsx4","wlsx5","wlsx6", _
        "kehu","kehulb","khsx1","khsx2","khsx3","khsx4","khsx5","khsx6", _
        "ghs","ghslb","ghssx1","ghssx2","ghssx3","ghssx4","ghssx5","ghssx6", _
        "gongchang","gongchanglb","gcsx1","gcsx2","gcsx3","gcsx4","gcsx5","gcsx6", _
        "cangku","cangkulb","kuwei","cksx1","cksx2","cksx3","cksx4","cksx5","cksx6"
        'e.Cancel = False   '初始加载表以外的表打开时都不加载数据
    Case Else '其他所有表默认打开时都不加载数据
        e.SelectString="select * fr++om " & e.DataTableName & " where id is null"
End Select
'设置外部表初始加载条件(不加载数据)