Question

esql 游标查询时，最后一条记录重复？

这是我写的esql，查询。。。
EXEC SQL BEGIN DECLARE SECTION ;
INT status;
CHAR sno[10],sname[15],city[20];
EXEC SQL END DECLARE SECTION ;
EXEC SQL INCLUDE SQLCA;
main()
{
int i;
EXEC SQL DATABASE "sx";
EXEC SQL DECLARE cursor1 CURSOR FOR SELECT * FROM S_TEST;
EXEC SQL OPEN cursor1 ;
printf("sno sname status city\n ");
while(SQLCODE==0)
{
EXEC SQL FETCH NEXT cursor1 INTO :sno,:sname,:status,:city ;
printf("%8s %8s %8d %8s \n",sno,sname,status,city);
}
EXEC SQL CLOSE cursor1 ;
EXEC SQL DISCONNECT CURRENT;
}

Answer 1

,要想使SQL语言能与宿主语言通讯,ESQL提供了游标操作, ... ESQL中的DECLARE CURSOR语句定义游标,赋给它一个与查询相关的游标名.