- Foxtable(狐表) (http://foxtable.com/bbs/index.asp)
-- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2)
---- [求助]帮忙看看 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=141417)
-- 发布时间：2019/9/28 16:38:00
-- [求助]帮忙看看
Dim jb As New SQLJoinTableBuilder("流向查询表","客户表")
Dim Cols1() As String ={"品名","规格","医疗机构"}
Dim Cols2() As String ={"品名","规格","医疗机构"}
jb.Addtable("客户表",Cols1,"流向表",cols2)
jb.AddCols("所属区域","医院等级","客户","联系方式","开票时间","{客户表}.医疗机构","{客户表}.品种","{客户表}.规格","单价","数量")
jb.AddExp("金额","数量*单价")
jb.Build()
MainTable = Tables("流向查询表")
执行时出现“至少有一个参数没有被指定值”，求助！
-- 发布时间：2019/9/28 16:53:00
--
Dim jb As New SQLJoinTableBuilder("流向查询表","客户表")
Dim Cols1() As String ={"品名","规格","医疗机构"}
Dim Cols2() As String ={"品名","规格","医疗机构"}
jb.Addtable("客户表",Cols1,"流向表",cols2)
jb.AddCols("所属区域","医院等级","客户","联系方式","开票时间","{客户表}.医疗机构","{客户表}.品种","{客户表}.规格","单价","数量")
jb.AddExp("金额","数量*单价")
msgbox(jb.Buildsql) \'这里显示什么SQL？
红色的列还有没有哪个是2个表都有的，列名是否都正确
-- 发布时间：2019/9/28 17:15:00
--
此主题相关图片如下：qq图片20190928171144.png
此主题相关图片如下：qq图片20190928171103.png
没有重复的列，列名也都正确
此主题相关图片如下：qq图片20190928170923.png
-- 发布时间：2019/9/28 17:19:00
--
知道了，是品种，不是品名。。。