SQLCrossTableBuilder 多表统计，卡死 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

如下代码，查询超出时间，设置为600秒，直接卡死不动。。。不知道是不是代码有问题。。。

Dim bd1 As New SQLcrossTableBuilder("统计表1","动销sku数")
    bd1.C
    'Dim Cols1() As String = {"库位","门店","调整期间"}
    'Dim Cols2() As String = {"库位","门店","调整期间"}
    Dim Cols1() As String = {"关联列"}
    Dim Cols2() As String = {"关联列"}
    bd1.AddTable("动销sku数",Cols1,"库位销售分析",Cols2)
    bd1.HGroups.AddDef("{库位销售分析}.门店") '添加客户列用于水平分组
    bd1.HGroups.AddDef("{库位销售分析}.库位") '添加客户列用于水平分组
    bd1.HGroups.AddDef("销售日期",DateGroupEnum.year,"区间") '添加客户列用于水平分组
    bd1.vGroups.AddDef("{库位销售分析}.调整期间","调整期间_{0}") '添加客户列用于水平分组
    bd1.Totals.AddDef("销售数量","销量") '添加数量列用于统计
    If e.Form.Controls("CheckBox8").checked = True Then
        bd1.Totals.AddDef("动销数") '添加数量列用于统计
    End If
Tables(e.Form.Name & "_table1").DataSource = bd1.BuildDataSource()

反过来设置也是一样：

Dim bd1 As New SQLcrossTableBuilder("统计表1","库位销售分析")
    bd1.C
    'Dim Cols1() As String = {"库位","门店","调整期间"}
    'Dim Cols2() As String = {"库位","门店","调整期间"}
    Dim Cols1() As String = {"关联列"}
    Dim Cols2() As String = {"关联列"}
    bd1.AddTable("库位销售分析",Cols1,"动销sku数",Cols2)

[此贴子已经被作者于2016/7/20 17:43:22编辑过]

主题：SQLCrossTableBuilder 多表统计，卡死