高分求解：VF表格控件问题

[geny]

this.tag="SELECT Hyjbk.xm, Hyjbk.xb, Hyjbk.sfzh, Khjbk.kx, Khjbk.kye ";
+"FROM hykk!hyjbk INNER JOIN hykk!khjbk ";
+"ON Hyjbk.sfzh = Khjbk.sfzh ";
+"WHERE Khjbk.kh ="+ allt(thisform.text1.value);
+" INTO CURSOR khsearch"
as
thisform.grid1.recordsource=this.tag

为什么，提示record=1，而表格没有显示，请问这是怎么回事，我的grid属性都设置对了

[rida]

你试试
thisform.grid1.requery
如果没有显示你看看你的sql语名有没有问题，
可有这样试
cSql="SELECT Hyjbk.xm, Hyjbk.xb, Hyjbk.sfzh, Khjbk.kx, Khjbk.kye ";
+"FROM hykk!hyjbk INNER JOIN hykk!khjbk ";
+"ON Hyjbk.sfzh = Khjbk.sfzh ";
+"WHERE Khjbk.kh ="+ allt(thisform.text1.value);
+" INTO CURSOR khsearch"
&cSql
brow
如果显示的是临时表khsearch的内容则sql语句没有问题。

[zhongyj]

->
this.tag="SELECT Hyjbk.xm, Hyjbk.xb, Hyjbk.sfzh, Khjbk.kx, Khjbk.kye ";
+"FROM hykk!hyjbk INNER JOIN hykk!khjbk ";
+"ON Hyjbk.sfzh = Khjbk.sfzh ";
+"WHERE Khjbk.kh ="+ allt(thisform.text1.value);
+" INTO CURSOR khsearch"
thisform.grid1.recordsourcetype=3
thisform.grid1.recordsource=this.tag
thisform.grid1.refresh

[daniel2008]

up