Se lect * From {采购订单} Where [_Identify] Is Null
采购订单分析_Button3_Click
Dim tb As Table =
Tables(e.Form.Name & "_Table3")
Dim dt As
DataTable = tb.DataTable
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 &
"#"
dt.LoadFilter = Filter '设置加载条件
dt.Load() '加载数据
错误提示
.NET Framework 版本:2.0.50727.5485
Foxtable 版本:2017.4.22.1
错误所在事件:加载[采购订单分析_Table3]失败!
详细错误信息:
'#' 附近有语法错误。