| 以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- SQL报错 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=169936) |
| -- 作者：lin98 -- 发布时间：2021/7/6 18:17:00 -- SQL报错 \'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 & "\'" and 审核 =\' \' and 制单人=\'" & User.name & "\'" 上面SQL数据源，报错制单日期未声明
|
| -- 作者：有点蓝 -- 发布时间：2021/7/6 20:32:00 -- 多看几遍：http://www.foxtable.com/webhelp/topics/1284.htm Filter = "制单日期>= \'" & dt1 & "\' And 制单日期<= \'" & dt2 & "\' and 审核 is null and 制单人=\'" & User.name & "\'"
|