**click事件中,先将grid1的数据设为NULL
thisform.grid1.recordsource=NULL
**执行选择语句:
sele * from zjtzb where rq>a1 and rq<a2 and jsr=b and xlb=c into table lsb
**然后重新设置数据源:
thisform.grid1.recordsource='lsb'
**退出文件时。删除临表 lsb就对了。
DROP table lsb(这个语句放在何处你要试验一下)
或者你试试。这种方法我怕行不通。我没怎么测试过
sele * from zjtzb where rq>a1 and rq<a2 and jsr=b and xlb=c into cursor lsb
thisform.grid1.recordsource='lsb'
[ 本帖最后由 wjp456789 于 2012-11-9 21:37 编辑 ]
thisform.grid1.recordsource=NULL
**执行选择语句:
sele * from zjtzb where rq>a1 and rq<a2 and jsr=b and xlb=c into table lsb
**然后重新设置数据源:
thisform.grid1.recordsource='lsb'
**退出文件时。删除临表 lsb就对了。
DROP table lsb(这个语句放在何处你要试验一下)
或者你试试。这种方法我怕行不通。我没怎么测试过
sele * from zjtzb where rq>a1 and rq<a2 and jsr=b and xlb=c into cursor lsb
thisform.grid1.recordsource='lsb'
[ 本帖最后由 wjp456789 于 2012-11-9 21:37 编辑 ]
我是来向高手学习的!