以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- [求助]SQLGroupTableBuilder语句 (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=24186) |
-- 作者:jspta -- 发布时间:2012/10/7 10:44:00 -- [求助]SQLGroupTableBuilder语句 以下代码中BuildDataSource为什么会报错哪?使用build就没问题,求教 Dim sqlGTB As new SQLGroupTableBuilder("统计","原始表") With sqlGTB .ConnectionName = OA_DataBase .Groups.AddDef("列1") .Groups.AddDef("列2") Tables(e.form.Name & "_Table1").DataSource = sqlGTB.BuildDataSource() End With 少了行统计 .Totals.AddDef("列3")
[此贴子已经被作者于2012-10-7 11:37:42编辑过]
|
-- 作者:sloyy -- 发布时间:2012/10/7 22:27:00 -- Dim sqlGTB As new SQLGroupTableBuilder("统计","原始表")
With sqlGTB
.ConnectionName = OA_DataBase
.Groups.AddDef("列1")
.Groups.AddDef("列2")
.bulid
End With
Tables(e.form.Name & "_Table1").DataSource = "统计"
|