- 论坛徽章:
- 0
|
各位大虾:
在INFORMIX-ESQL/C编程中,取游标时出错。SQLCODE=-439 errmsg=Database server is currently processing SQL task.
请问如何解决?
程序的源代码如下(在while中的那个读取游标的时候出错):
//声明游标
EXEC SQL declare c_cart cursor with hold for
select rowid,domain
from cart_detail
where cart_id=:i_serial ;
//打开 cursor
EXEC SQL open c_cart;
if (check_sqlerr(TITLE_REGISTER)) {
EXEC SQL free c_cart;
show_err("出错");
}
EXEC SQL fetch c_cart into :i_rowid, :s_cart_domain;
if (check_sqlerr(TITLE_REGISTER)) {
EXEC SQL close c_cart;
EXEC SQL free c_cart;
show_err("出错");
}
while(SQLCODE==0){
EXEC SQL fetch c_cart into :i_rowid, :s_cart_domain;
if (check_sqlerr(TITLE_REGISTER)) {
EXEC SQL close c_cart;
EXEC SQL free c_cart;
show_err("出错");
}
}
} |
|