pb 动态分组

来源:互联网 发布:淘宝逆战天梯是开挂吗 编辑:程序博客网 时间:2024/05/19 02:44
窗口中做一个选择分组的条件DropDownListBox:ddlb_1,初始化赋值为选择的列名

String   ls_SqlBase,ls_SqlGroup,ls_selColumn

ls_SqlBase   =   'Select   ...   From   ...   Where   ... '
动态选择ddlb_1某列后
ls_SelColumn   =   ddlb_1.Text
ls_SqlGroup   =   ls_Sqlbase   +   '   Group   by   '   +   ls_selColumn

dw_1.SetSqlSelect(ls_SqlGroup)
dw_1.SetTransObject(Sqlca)
dw_1.ReTrieve()