郁闷中，高手来解释一下这个错误

[llix_cm]

SQLSTATE = S1000
[Microsoft][ODBC SQL Server Driver]connection is busy with results for another hstmt

相关源码:
declare area cursor for select distinct name from name order by name;
open area;
fetch area into :toto;
if sqlca.sqlcode<0 then
messagebox("database error",sqlca.sqlerrtext,exclamation!)
return
end if
do while sqlca.sqlcode =0
insert into inputtemp (zhibiao1,zhibiao2,zhibiao3,zhibiao4,zhibiao5,zhibiao6,zhibiao7,zhibiao8,zhibiao9,zhibiao10,zhibiao11,zhibiao12,zhibiao13,zhibiao14,zhibiao15,tempid,name) values('0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,:toto);
fetch area into :toto;
loop
close area;

[愉快的登山者]

所访问的数据已被其他程序锁住，需要等待。

[llix_cm]

那有没有方法解决这个问题那。我没有其他的数据库应用了，重启也一样。

[xirumin]

是否死锁了？可以在企业管理器中查看一下。或在查询分析器中跟踪一下。

[llix_cm]

在查询分析器中完全正常啊，是怎么回事啊
truncate table inputtemp
declare @toto varchar(20)
declare area cursor for select distinct name from name order by name;
open area;
fetch area into @toto;
if @@FETCH_STATUS<0
BEGIN
return
end
while @@FETCH_STATUS =0
BEGIN
insert into inputtemp (zhibiao1,zhibiao2,zhibiao3,zhibiao4,zhibiao5,zhibiao6,zhibiao7,zhibiao8,zhibiao9,zhibiao10,zhibiao11,zhibiao12,zhibiao13,zhibiao14,zhibiao15,tempid,name) values('0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,@toto);
fetch area into @toto;
end
close area;
select * from inputtemp

[cooltnt]

[Microsoft][ODBC SQL Server Driver]connection is busy with results for another hstmt

有hstmt这张表同时操作数据吗？

[llix_cm]

hstmt不知道是什么东西。没有这张表的