Re: FREEing the cursor, etc

David Williams wrote: > > In article <34CF5145.6E54@bellsouth.net>, W. H. SMITH > <carlson1@bellsouth.net> writes > >The other recommendation was not so clear (Freeing the cursor / prepared > >statement). > > > >My understanding of 4GL was that the cursor / prepared statements were > >FREEd when the cursor was closed. Is there something I'm missing? > > I believe this changed in 4.1 / 6.0, now you need to free the cursor > and free the prepared statement. I think 4.1 meant you had to free one > and that would automatically free the other. In 6.x you must free both > of them separately. I believe this is correct. However, the original statement, that "cursor / prepared statements were FREEd when the cursor was closed" was never true. When the cursor is closed, it is simply closed. It can be re-opened. It still uses resources. Once it is freed, the resources are released, and it \\ must be re-prepared/re-declared before being re-used. -- June ---- June Tong Informix Software ---- ---- Senior Consultant (650) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ----