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