游标，又见游标：（救命啊

liuyanghr

我在程序中定义游标：
char statement[200];
strcpy(statement, "select * from tablename";
exec sql declare cur cursor for :statement;
exec sql open cur;

出错：sqlcode = -16843026
为什么不可以呢？

郁闷

liuyanghr

我改了一下，可是还错：
char statement[200];
strcpy(statement, "select * from tablename";
exec sql prepare sqlstate from :statement;
exec sql declare cur cursor for sqlstate;
exec sql open cur;

现在的错误：
A cursor must be declared before this command type can be initialized.

为什么？