the sql error -1
-
when using embeded sql,i declare and open a cursor in a function which worked well,and fetch record from the cursor in other function,the problem was that the record had been fetched,but the return sql code was -1,why? and the other problem:the similar problem occured when declare and open a cursor,the return sql code was -1,it's bad result. thans!
-
when using embeded sql,i declare and open a cursor in a function which worked well,and fetch record from the cursor in other function,the problem was that the record had been fetched,but the return sql code was -1,why? and the other problem:the similar problem occured when declare and open a cursor,the return sql code was -1,it's bad result. thans!
Without some sort of sample code, my guess would be that your cursor isn't declared as a global cursor, and you're having scope issues trying to access it from different routines.
Grim
(aka Toby)
MCDBA, MCSD, MCP+SB