Re: New Era -1363 Error

In article <4dsva7$5rq@s02.pavilion.co.uk>, iank@pavilion.co.uk (iank) wrote: >We get a lot of -1363 memory errors in New Era. Seems to be caused if you try >and assign nothing to a variable. This might be as a result of trying to get >data from an empty superfield or the results of an sql query once notfound has >been reached. > >It is as if New Era actually does assign nothing to the variable rather than a >zero length null terminated string. This is the way Informix-4GL works, and so how Informix-NewEra should work too. A SELECT that doesn't return any rows does NOT reset the variables, so: LET x = 12345 SELECT some_number INTO x FROM some_table WHERE 1=0DISPLAY x will display 12345, not zero or NULL. ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.4 Oct 95 Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/ New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/ftp/pub/informix/