abki wrote:Open can be very havy if where-clause isnt good.
Check tables in declare and the joins. Any wrong can takes days to execute.
U can try to take only 1 table and add the oter 1 at time.
You have joined this forum today, and rather than lurking a bit to see what kind of behaviour is expected, you have been posting willy-nilly, seemingly without paying any attention to the replies already given in the various threads, in essence wasting the time of those of us who subscribe to get new replies to threads.
In this case the TS stated that he tested the cursor in SPUFI where it worked without problems.