Re: 4GL Problem

naomi@qip.anasazi.com writes: |> > Tue Aug 3 04:28:41 MST 1993 |> > + fglgo /prod/fs/support/supexec/support/bin/Olabs -Dfsoff -SNAME |> > Program stopped at "labs2.4gl", line number 135. |> > SQL statement error number -270. |> > Could not position within a temporary file. |> > SYSTEM error number -101. |> > ISAM error: file is not open. Looks like bug #15937. Presumably this would be fixed in the 4.12 batch of releases, though our database does not confirm that. Although it is not listed as a workaround, you might try FREEing the cursor after you close it. |> Here is the code (labs2.4gl - with line numbers) at which the above |> error complains: |> |> > 120 |> > 121 DECLARE c2 CURSOR FOR |> > 122 SELECT request, sum(xnumber) |> > 123 FROM dir |> > 124 WHERE request MATCHES p_request |> > 125 AND print_date = 1 |> > 126 GROUP BY request |> > 127 ORDER BY request |> > 128 OPEN c2 |> By my assertion that the problem is in informix, I strongly expect |> that it is a problem with Informix Online and not with Informix 4gl. The bug is listed as a 4gl bug. Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney