以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 外部数据源加载报错 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=169810) |
-- 作者:lgz518 -- 发布时间:2021/7/1 10:30:00 -- 外部数据源加载报错 外部数据源加载报错 Dim y As Integer = Date.Today.Year Dim m As Integer = Date.Today.Month Dim dt1 As New Date(y, m, 1) Dim dt2 As New Date(y, m, Date.DaysInMonth(y, m)) \'获取本月的最后一天 Dim Filter As String Filter = "制单日期>= #" & dt1 & "# And 制单日期<= #" & dt2 & "#" Filter ="审核=\'\'" Filter ="制单人=User.name" \' DataTables("表D").LoadFilter = Filter DataTables("表D").Load() .NET Framework 版本:4.0.30319.42000 Foxtable 版本:2021.5.29.1 错误所在事件:加载[表D]失败! 详细错误信息: 至少一个参数没有被指定值。 |
-- 作者:有点蓝 -- 发布时间:2021/7/1 10:37:00 -- 如果是SqlServer看看:http://www.foxtable.com/webhelp/topics/2343.htm Dim Filter As String Filter = "制单日期>= #" & dt1 & "# And 制单日期<= #" & dt2 & "# and 审核 is null and 制单人=\'" & User.name & "\'" |