主题：列名不同的表合并问题

将操作的主表放在第一位置，可将后面多表的数据合并到主表（后面各表都必须有姓名列作为参考列）
在主表（名称为“合并表”）设置窗口按钮公式：
ClearGrid(Grid) And Eval(mid(Rept(" And DeleteCol(Grid,2)",Cols-1),5)) And Eval("AddCol(Grid,"""+Substitute(Eval("ListCols("""+Substitute(Substitute(ListGrids(),"合并表|",""),"|",""")+""|""+ListCols(""")+""")"),"|",""",0, True ) And AddCol(Grid,""")+""",0, True )") And Eval("AppendRows("""+Substitute(Substitute(ListGrids(),"合并表|",""),"|",""") And AppendRows(""")+""")") And DelReptRows(Grid,"姓名") And DelFor(Grid,"姓名","=","") And MoveCol("姓名",1) And Eval("Eval(""EvalFor(Grid,""""""+Substitute(Substitute(Substitute(Eval(""Substitute(""""|@|#|"""",""""|"""",""""""+Substitute(Substitute(ListCols(Grid),""姓名|"",""""),""|"","""""")+""""|""""+Substitute(""""|@|#|"""",""""|"""","""""")+"""""")""),""@"","""""",""""FindText("""""""""+Substitute(Substitute(Substitute(ListGrids(),"合并表|",""),"|","/"),"/",""""""""",""""""""""),""#"","""""""""",""""""""姓名"""""""",""""""""="""""""",[姓名])"""",""""""),""|"","""""",""""="""","""""""") And EvalFor(Grid,"""""")+"""""",""""="""","""""""")"") And Eval(""EvalFor(Grid,""""""+Substitute(Substitute(Substitute(Eval(""Substitute(""""|@|#|"""",""""|"""",""""""+Substitute(Substitute(ListCols(Grid),""姓名|"",""""),""|"","""""")+""""|""""+Substitute(""""|@|#|"""",""""|"""","""""")+"""""")""),""@"","""""",""""FindText(""""""""")+""""""""",""""""""""),""#"","""""""""",""""""""姓名"""""""",""""""""="""""""",[姓名])"""","""""&

egd文件下载

-=-=-=- 以下内容由 wjq1072 在 2012年03月11日 03:32pm 时添加 -=-=-=-
你的两个表列数不一样，33、32

一、可以设置两个表达式变量：（两个表的列数一样，用这个方法不容易出错！）
1、[%采集数据库%]
表达式：Substitute(ListCols("采集数据库"),"|",",")

2、[%抄表明细采集数据库%]
表达式：Substitute(ListCols("抄表明细采集数据库"),"|",",")

二、在“采集数据库”表窗口按钮设置公式：（运算好像快一些）
ClearGrid("采集数据库") And Eval("AppendFor(""抄表明细采集数据库"","""+[%抄表明细采集数据库%]+""","""+[%采集数据库%]+""")") And DelRow("采集数据库",1)

三、在“抄表明细采集数据库”表窗口按钮设置公式：（运算好像慢一些）
ClearGrid("采集数据库") And Eval("CopyFor(""采集数据库"","""+[%采集数据库%]+""","""+[%抄表明细采集数据库%]+""")") And DelRow("采集数据库",1)