NowData=thisform.combo1.value
select * from &NowData where at(alltrim(thisform.text1.value),品名)>0 and at(alltrim(thisform.text2.value),产地)>0 into TABLE searchtemp
CLOSE DATA
USE searchtemp
thisform.grid1.RecordSource ="searchtemp"
thisform.grid1.RecordSource =NULL
NowData=thisform.combo1.value
select * from &NowData where at(alltrim(thisform.text1.value),品名)>0 and at(alltrim(thisform.text2.value),产地)>0 into TABLE searchtemp
CLOSE DATA
USE searchtemp
thisform.grid1.RecordSource ="searchtemp"
我表单search(在顶层表单中)一个查询按钮有以下代码
NowData=thisform.combo1.value
select * from &NowData where at(alltrim(thisform.text1.value),品名)>0 and at(alltrim(thisform.text2.value),产地)>0 into cursor searchtemp
select (juststem(nowdata))
use
select searchtemp
thisform.grid1.RecordSource ="searchtemp"
当单独运行该表单时,
select (juststem(nowdata))
use
起了作用,即释放了该部分查询占用的内存
当通过程序运行主表单main(顶层表单),main打开的同时自动打开子表单search,再运行查询时,居然发现占用的内存并不会比释放,请问原因何在?