|
#2
吹水佬2022-02-19 09:53
|
程序代码：Create CURSOR b1 (jnh n(2),m1 c(2),m2 c(2))
insert into b1 values (1,"M1","")
insert into b1 values (2,"","M2")
insert into b1 values (3,"M1","")
insert into b1 values (4,"M1","")
insert into b1 values (5,"","M2")
insert into b1 values (1,"M1","")
insert into b1 values (2,"","M2")
insert into b1 values (3,"M1","")
insert into b1 values (4,"M1","")
insert into b1 values (5,"","M2")
查询!EMPTY(m1)时的下一条记录
结果是：
只有本站会员才能查看附件，请 登录
查询代码：
程序代码：IF USED("tmp")=.T.
SELECT tmp
USE
ENDIF
SELECT * FROM b1 INTO table tmp
SELECT b1.* FROM tmp,b1 wher !EMPTY(tmp.m1) AND tmp.recn()==b1.recn()+1
SELECT tmp
USE
ENDIF
SELECT * FROM b1 INTO table tmp
SELECT b1.* FROM tmp,b1 wher !EMPTY(tmp.m1) AND tmp.recn()==b1.recn()+1
报“找不到对象b1”
问题在哪？谢谢！
[此贴子已经被作者于2022-2-19 09:32编辑过]