想要同时显示两个表格中的数据 grid1 中应该要同时显示 1-13 的记录 可是显示没有
查询的代码是：
select adminl
thisform.pageframe1.page5.grid1.recordsourcetype = 4   
thisform.pageframe1.page5.grid2.recordsourcetype = 4
 
thisform.pageframe1.page5.grid1.recordsource="select adminl.number,joint,name,nationality from adminl where mod(recno(),2)=1"
thisform.pageframe1.page5.grid2.recordsource="select adminl.number,joint,name,nationality from adminl where mod(recno(),2)=0"

thisform.pageframe1.
thisform.refresh

请问哪位大佬可以帮忙解决以下

我与你对VFP的理解不同啊，我的认识是这样的：
select adminl
copy to temp1 for mod(recno(),2)=1
copy to temp2 for mod(recno(),2)=0
use temp1 in 0
thisform.pageframe1.page5.grid1.RecordSourceType= 1
thisform.pageframe1.page5.grid1.recordsource="temp1"
use temp2 in 0
thisform.pageframe1.page5.grid2.RecordSourceType= 1
thisform.pageframe1.page5.grid2.recordsource="temp2"
thisform.refresh

试试

谢谢各位了
我用了这个方法：
select adminl
thisform.pageframe1.page5.grid1.recordsourcetype = 1   
thisform.pageframe1.page5.grid2.recordsourcetype = 1
 
select adminl.number,joint,name,nationality from adminl where mod(recno(),2)=1 into cursor ji
thisform.pageframe1.page5.grid1.recordsource="ji"
select adminl.number,joint,name,nationality from adminl where mod(recno(),2)=0 into cursor ou
thisform.pageframe1.page5.grid2.recordsource="ou"

thisform.pageframe1.
thisform.refresh