Question

vfp表单设计综合查询按钮的命令程序怎么写

要做的是一个图书馆的借阅查询，查询按钮的命令如下，读者编号和书籍编号文本框的程序如图，请问各位大神怎么改，麻烦了麻烦了close allIF thisform.pageframe1.page3.text1.value="shujibianhao" SELECT * FROM jieyuexinxibiao WHERE jieyuexinxibiao.shujibianhao=thisform.text1.Value; INTO CURSOR result thisform.grid1.RecordSource ="result" thisform.grid1.Refresh ENDIFIF thisform.pageframe1.page3.text1.value="shujimingcheng" SELECT jieyuebianhao.duzhebianhao,duzhexingming,shujibianhao,shujimingcheng,chujieriqi,huanshuriqi,beizhuxinxi; FROM jieyuexinxibiao INNER JOIN shujixinxibiao; ON jieyuexinxibiao.shujibianhao=shujixinxibiao.shujibianhao; WHERE shujixinxibiao.shujimingcheng=thisform.text1.Value; INTO CURSOR result thisform.grid1.RecordSource ="result" thisform.grid1.Refresh ENDIF
就目前这个程序，我点了查询以后，一片空白





Answer 1

你的代码使用了 

这样的话除非你在 txt文本框里面填写“shujubianhao” 这串字符 ， 你的if条件语句才能执行，  所以你的条件设置语句有错误