Question

SQL中的游标什么时候搜索结束

printf("输入电影名称\n");
scanf("%s",where);
EXEC SQL DECLARE titleCursor CURSOR FOR
select title,iyear,length,genre,studioname,producerc
from movies
where title=:where;
EXEC SQL OPEN titleCursor;
EXEC SQL FETCH titleCursor INTO :title, :iyear, :length,:genre,:studioname,:producerc;
printf("%s %d %d %s %s %d\n",title,iyear,length,genre,studioname,producerc);
EXEC SQL CLOSE titleCursor;
break;
比如上面有三条结果，
EXEC SQL FETCH titleCursor INTO :title, :iyear, :length,:genre,:studioname,:producerc;
printf("%s %d %d %s %s %d\n",title,iyear,length,genre,studioname,producerc);
这边怎么改？

Answer 1

declare @a int
declare t1 CURSOR for select Fielda from tablename
open t1
FETCH NEXT FROM t1 INTO @a
WHILE (@@FETCH_STATUS = 0)
BEGIN
--do something
FETCH NEXT FROM t1 INTO @a
END
CLOSE t1
DEALLOCATE t1