Re: Q.Cursors with hold closed by commit/Temp tables disappear.

Peter Tashkoff (TASHKOP@kiwi.co.nz) wrote: : Has anyone come across a situation whereby a : cursor declared with hold calls a function which : commits. The called function appears to close the : cursor. : A workaround was tried whereby a while loop and a : temp table were used. But the temp table disappears : also on the return from the function which commits. : Environment is solaris 2.4 Online 7.12, tools 6.01. I tested your hold cursor problem on OnLine 7.12.UC1 w/ 6.03.UC1 4GL, and on OnLine 7.11.UC1 w/ 6.01.UD1 4GL (both HP -- sorry, I couldn't easily find your particular environment) and it works just fine for me. My guess is that your function actually changes databases. When you close the database, your cursor automatically gets closed (and freed, or should, but it might depend on whether you're using RDS or compiled 4GL), and any temp tables get dropped. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Miami ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.