请教,pb对ACCESS使用游标访问的问题?
DECLARE mycur CURSOR FOR
SELECT bxg.gh,bxg.addup
FROM bxg;
open mycur;
i=0
fetch mycur into :temp_gh,:temp_addup;
do while (sqlca.sqlcode = 0)
i++
insert into lab_collect values (:i,:temp_gh,:temp_addup);
fetch mycur into :temp_yearday,:temp_bm,:temp_xz,:temp_gh,:temp_addup;
loop
close mycur;
请教各位大侠,这段使用有何问题,为什么系统说“cursor is not open”