 加好友  发短信
等级：小狐
帖子：324
积分：3807
威望：0
精华：0
注册：2008/9/1 7:34:00
|
[求助]下列易表语句在FOXTABLE中怎样写？  Post By：2008/11/11 10:41:00 [显示全部帖子]
下列两段易表语句在FOXTABLE中怎样写？谢谢！
语句1、
ClearGrid("流水表") And AddRows("流水表",[另表!Rows]-1) And evalfor("流水表","正课_姓名","cell(row,1,""另表"")") And evalfor("流水表","正课_课时","cell(row,2,""另表"")")
语句2、
按纽公式：
ClearGrid("另表") And AddRows("另表",Rows*Cols) And SetVariable("%B%",[%A%]) And EvalFor("另表","姓名","Split([%B%],""|"",Row)") And DelFor("另表","姓名"," = ","") And EvalFor("另表","出现次数","CountFor(""另表"",""姓名"",""="",[姓名])") And DelReptRows("另表","姓名") And OpenGrid("另表") And DelFor("另表","姓名"," = ","")
变量%A%，表达式：
Eval("Substitute(ListFor(""表2"","""+Substitute(ListCols("表2"),"|",""",2),""、"",""|"")+""|""+Substitute(ListFor(""表2"",""")+""",2),""、"",""|"")")
变量%B%，字符型。
[此贴子已经被作者于2008-11-11 11:07:50编辑过]
|
|
