Re: CLOSE and FREE
In article <3euinh$sbn@emory.mathcs.emory.edu>,
johnl@informix.com (Jonathan Leffler) wrote:
> >Subject: Re: CLOSE and FREE
> So, CLOSE indicates that the cursor is not needed for the time being.
[snip]
> To indicate that you have no further interest in the cursor at
> all, you FREE the cursor.
So shouldn't this sample program NOT work? (Because it does on our 4.10.UC1
4GL-RDS and 5.02.UC2 SE system):
---------------------------------
MAIN
DEFINE i SMALLINT,
l_tabname CHAR(18)
DATABASE yourdatabase -- You'll want to change this
DECLARE test_curs CURSOR FOR
SELECT tabname
FROM systables
FOR i = 1 TO 2
OPEN test_curs -- Shouldn't this line barf on the 2nd iteration?
FETCH test_curs INTO l_tabname
DISPLAY "i = ", i, " ", l_tabname
CLOSE test_curs
FREE test_curs
END FOR
END MAIN
---------------------------------
--------------------------------------,-------------------------------------
Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ
Quanta Systems, Auckland, New Zealand | kcbbs.gen.nz:/informix/*
| mathcs.emory.edu:/pub/informix/faq/*
+64 9 377-4473 (work) 276-5546 (home) | quasar.ucar.edu:/?