如何判定某列有无记录
如表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编辑过]