主题：2011年6月19日更新，从今不再为SQL语言烦恼

SQLJoinTableBuilder和统计工具的示例代碼沒更正!

過時錯誤示例

打开CaseStudy目录下的文件"多表统计.Table"，然后在命令窗口测试下面的代码：

Dim jb As new SQLJoinTableBuilder("查询表1","订单")
jb.ConnectionName = "Sale"
jb.AddTable("订单","产品Id","产品","产品ID")
jb.AddCol("产品","产品名称","产品")
jb.AddCols("订单", "日期", "数量","单价")
jb.AddExp("订单","[数量] * [单价]","金额")

Dim cb As new CrossTableBuilder("统计表1",jb.BuildSQL,"Sale")
cb.HGroups.AddDef("产品")
cb.VGroups.AddDef("日期",DateGroupEnum.Year,"{0}年")
cb.Totals.Adddef("数量")
cb.Totals.AddDef("金额")
cb.Build()

應為:

Dim jb As new SQLJoinTableBuilder("查询表1","订单")

jb.AddTable("订单","产品Id","产品","产品ID")

jb.AddExp("产品","产品名称")

jb.AddCols("日期", "数量","单价")

jb.AddExp("金额","[数量] * [单价]")

Dim cb As new CrossTableBuilder("统计表1",jb.BuildSQL,"Sale")

cb.HGroups.AddDef("产品")

cb.VGroups.AddDef("日期",DateGroupEnum.Year,"{0}年")

cb.Totals.Adddef("数量")

cb.Totals.AddDef("金额")

cb.Build()