Re: CURSOR STATMENT

Conix (conizzol@pippo.sm.dsi.unimi.it) wrote: : I have some problem with the use of CURSOR STATMENT in ESQL/C programming. : When I declare a cursor, in a correct mode, and I start a FOR STATMENT to : fetch every rows wich I want to see with my cursor, if in this FOR i call : a procedure, for every statment wich this procedure contains, the cursor : lost the remainig rows, wich I want to see. : Thanks in advance. Conix. Hi, Is this roughly what you are doing $declare cursor; $open cursor; for (??) /* should you use a while () */ { $fetch cursor into $xyz; if (sqlca.sqlcode) break; called_procedure(); }; or do you mean you use a function called in the for statement to fetch each row? Precisely how are you breaking out of your loop? Is your called procedure scrolling the cursor in any way? Is your sqlcode checking checking the return codeof the fetch on the cursor or some other select you may be doing? --------------- pcs@mpx.com.au - Signature under construction ---------------