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









