主题：[讨论] QueryBuilder　中能引用全局变量吗？

Dim q As new QueryBuilder
q.TableName = "会计凭证查询"
q.C
q.SelectString = "select * from [z_tablqpz] where sszt = 11 and pzrqn = " & vars("kn")  &  " union all select * from [z_tabdqpz] where sszt = 11 and pzrqn = 2008 union all select * from [z_tabxqpz] where sszt = 11 and pzrqn = 2008 order by pzrqn,pzrqy,pzlx,pzdm,flxh"
q.Build

和全局变量无关的，也许后面的2008也要处理。
不要急于下结论使全局变量的事，任何表达式都可以动态合成。

q.SelectString = "select * from [z_tablqpz] where sszt = 11 and pzrqn = " & vars("kn")  &  " union all select * from [z_tabdqpz] where sszt = 11 and pzrqn = 2008 union all select * from [z_tabxqpz] where sszt = 11 and pzrqn = " & vars("kn")  &  " order by pzrqn,pzrqy,pzlx,pzdm,flxh"

要学会调试，例如你可以在命令窗口：

dim str =  "select * from [z_tablqpz] where sszt = 11 and pzrqn = " & vars("kn")  &  " union all select * from [z_tabdqpz] where sszt = 11 and pzrqn = 2008 union all select * from [z_tabxqpz] where sszt = 11 and pzrqn = " & vars("kn")  &  " order by pzrqn,pzrqy,pzlx,pzdm,flxh"
output.show(str)

看看所生成的sql语句是什么，如果觉得没问题，复制这个生成好的sql到查询表定义窗口进行测试。

呵呵，我会考虑的。