主题：关于删除delfor()问题

delFor("销售一","AAA","=",[CCC])
[CCC]只返回的一个当前值
我想达到的删除目的是删除"销售一表AAA列"与"销售二表CCC列"相同的内容的记录egd文件下载

用按钮公式：Eval("DelFor(""销售一"",""AAA"",""="","""+Substitute(ListFor("销售二","CCC"),"|",""") And DelFor(""销售一"",""AAA"",""="",""")+""")")试试？

太感谢版主了!这样能够实现我想要的功能,可是表达式看了二十多分钟我还是没弄明白,能不能辛苦版主给讲解下!!
Substitute(ListFor("销售二","CCC"),"|",""") 列出销售二表CCC列的值,并将|替换为",其结果是把111|222|333替换成了111"222"333

DelFor(""销售一"",""AAA"",""="",""")这里为什么都要用到两个引号,
删除"销售一"表中"AAA"列等于引号"的内容????还是用到双引号,变成了一个表达式而不去执行结果变为"销售一"表中"AAA"等于"号的表达式
放在一起我就更晕了!!

http://bbs.egrid2000.com/cgi-bin/topic.cgi?forum=2&topic=30&show=25

终于弄明白了,受益非浅啊!Eval的功能强大,表达式相加得出最后的表达式,
想出这招的人够历害的!
真的要特别感谢wjq1072 版主!!

Eval("DelFor(""销售一"",""AAA"",""="","""+Substitute(ListFor("销售二","CCC","到期日期","<=" ,Today()),"|",""") And DelFor(""销售一"",""AAA"",""="",""")+""")")
wjq1072 版主再帮我看看,
ListFor("销售二","CCC","到期日期")
改为ListFor("销售二","CCC","到期日期","<=" ,Today())
怎么就不好使了

egd文件下载

ListFor("销售二","CCC","到期日期","<=" ,Today())
应该为：ListFor("销售二","CCC","到期日期",Today())

这样试试？
Eval("DelFor(""销售一"",""AAA"",""="","""+Substitute(ListFor("销售二","CCC","到期日期",Today()),"|",""") And DelFor(""销售一"",""AAA"",""="",""")+""")")

SORRY,刚才是我把公式搞错了!!
我是想在销售二表里用FilterFor("到期日期", "<=" ,Today())筛选出记录,
然后用Eval("DelFor(""销售一"",""AAA"",""="","""+Substitute(ListFor("销售二","CCC"),"|",""") And DelFor(""销售一"",""AAA"",""="",""")+""")")
这个按扭删除,可是这样做的结果是,ListFor("销售二","CCC")这个显示的是CCC整个列的内容,而不是筛选出来后CCC列的内容,
如果是这样的话,应该为：ListFor("销售二","CCC","到期日期",Today())出来的结果只是等于今天日期的记录,而小于今天日期的记录是不能显示的,
有什么办法吗??