如何判定某列有无记录
											如表1: 程序代码:
程序代码:create cursor b1 (jnh N(2),mm c(3),fmm c(3))
insert into b1 values (1,"","M2")
insert into b1 values (2,"","M2")
insert into b1 values (3,"","")
FOR i=2 TO FCOUNT()
    SELECT * FROM b1 WHERE !EMPTY(FIELD(i)) 
    RETURN
endfor    无法查询
 程序代码:
程序代码:create cursor b1 (jnh N(2),mm c(3),fmm c(3))
insert into b1 values (1,"","M2")
insert into b1 values (2,"","M2")
insert into b1 values (3,"","")
FOR i=2 TO FCOUNT()
    SELECT * FROM b1 WHERE !EMPTY(mm) 
    RETURN
endfor    可以查询
为什么?
判定某列有无记录用FIELD() 应怎么写?
[此贴子已经被作者于2020-11-1 21:05编辑过]



 
											





 
	    

 
	
 
											




