主题：[求助]自动增加列

怎样自动增加多列，[%产品列表%]是准备增加的产品列表。

-=-=-=- 以下内容由 还不错 在 2011年05月26日 04:15pm 时添加 -=-=-=-
列为数值型。

Eval("AddCol(Grid,"""+Substitute([%产品列表%],"|",""",1, True ) And AddCol(Grid,""")+""",1, True )")

执行后没反映呀。

可以了，谢谢。我忘了把变量类型改为表达式了。

还有一个问题要请教：如何将下面的刷新公式设置到新增加的列中。
SetColFormula(GridName,[%产品名称%],"if(SumFor(""材料明细"",""数量"",""供货单位"",""="",[单位],""送货地"",""="",[地点],""货物名称"",""="",ColName)=0,"""",SumFor(""材料明细"",""数量"",""供货单位"",""="",[单位],""送货地"",""="",[地点],""货物名称"",""="",ColName))")

Eval("AddCol(Grid,"""+Substitute([%产品列表%],"|",""",1, True ) And AddCol(Grid,""")+""",1, True )") And
Eval("SetColformula(Grid,"""+Substitute([%产品列表%],"|",""",""if(SumFor(""""材料明细"""",""""数量"""",""""供货单位"""",""""="""",[单位],""""送货地"""",""""="""",[地点],""""货物名称"""",""""="""",ColName)=0,"""""""",SumFor(""""材料明细"""",""""数量"""",""""供货单位"""",""""="""",[单位],""""送货地"""",""""="""",[地点],""""货物名称"""",""""="""",ColName))"") And SetColformula(Grid,""")+""",""if(SumFor(""""材料明细"""",""""数量"""",""""供货单位"""",""""="""",[单位],""""送货地"""",""""="""",[地点],""""货物名称"""",""""="""",ColName)=0,"""""""",SumFor(""""材料明细"""",""""数量"""",""""供货单位"""",""""="""",[单位],""""送货地"""",""""="""",[地点],""""货物名称"""",""""="""",ColName))"")")

十分感谢。

-=-=-=- 以下内容由 还不错 在 2011年05月26日 06:35pm 时添加 -=-=-=-
明天可能还会有问题麻烦总版主。

根据上述公式产生的数据，怎么进行汇总？(没有分组列)