I have an embedded sql program with a while loop. I declare and open a cursor before the while. The fetch forward next is inside the while. The first time through the while the cursor works perfectly the second time I get the error:
sql error PerformPortalFetch: portal "foo_crsr" not found I have implemented this sequence in other programs and it has worked flawlessly as it should. I cannot include the code here as it is proprietary. I was just wondering if anyone had seen anything like this before and could possibly shed some light on it. I am continuing to look on the net for solutions. Thanks for your help, Lynn ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
