修改失败是因为事务对象占用了吗?
declare CUR_roomcancel CURSOR FOR
select yd_df_roomid,yd_df_date
from yd_df
where yd_df_prearrangeid=:ii_preid;
open CUR_roomcancel;
do until ii_preid<0
FETCH CUR_roomcancel INTO :li_roomid,:ld_date;
if SQLCA.SQLCode=100 or SQLCA.SQLCode=-1 then exit
update yd_df
set yd_df_use = '0'
where yd_df_prearrangeid=:ii_preid and yd_df_roomid=:li_roomid and yd_df_date=:ld_date;
if sqlca.sqlcode=-1 then
rollback ;
messagebox("警告","数据库修改出错")
return -1
end if
运行时报错messagebox("警告","数据库修改出错"),如果是因为事物对象占用,那是否要重新注册一个事物对象给游标呢?