Dim bd1 As New SQLGroupTableBuilder("统计表11", "ABC_bmfzzz")
bd1.C
bd1.AddTable("ABC_bmfzzz","部门编号","责任中心档案","部门编号")
Dim dt1 As fxDataSource
bd1.Groups.AddDef("月份")
bd1.Totals.AddDef("借方金额","本年费用")
bd1.Filter = "年份 = " & tj1 & " and [科目编码] like '6602%' And (" & filter & ")"
dt1 = bd1.BuildDataSource()
问题可能在以下这句代码
bd1.Filter = "年份 = " & tj1 & " and [科目编码] like '6602%' And (" & filter & ")"
上述代码从SQL数据库视图中取不到数据,没错误提示,但去掉and [科目编码] like '6602%' 以后又可以取到数据,是不是这里的LIKE用法有误
[此贴子已经被作者于2019/8/20 10:17:43编辑过]