[求助]sql where 变量 Post By:2014/6/26 16:01:00 [显示全部帖子]
老师
SQL 条件到底如何引用变量
Dim txt As String = Forms("窗口1").Controls("TextBox1").value Dim q As new QueryBuilder q.TableName = "销量统计" q.SelectString = "Select 第一列,sum(第二列),第四列 From {表B}Where 第一列 = '&txt&' Group By 第一列,第四列" q.Build MainTable = Tables("销量统计")