以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- SQLCompute中的表达式分段合成 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=137549) |
-- 作者:lfz123 -- 发布时间:2019/7/9 14:06:00 -- SQLCompute中的表达式分段合成 我想把黄色背景部分 Dim v1 As Double = dt.SQLCompute("sum(余额)","一级码 = \'1001\'and 年份 = "& d.Year & " and 月份 = "& d.Month & " ") 改成分段合成的,如下,结果报错了? dim filter as string = "年份 = "& d.Year & " and 月份 = "& d.Month & "" Dim v1 As Double = dt.SQLCompute("sum(余额)","一级码 = \'1001\'and & filter") |
-- 作者:有点蓝 -- 发布时间:2019/7/9 14:39:00 -- 参考:http://www.foxtable.com/webhelp/topics/1284.htm Dim v1 As Double = dt.SQLCompute("sum(余额)","一级码 = \'1001\' and " & filter) |