Re: 4gl Error
Hi
This is a confirmed Informix bug for RDS 7.30 and 7.31.
One suggested workaround is to go back to 7.20.
Hope this helps
Steve Weet wrote in message
<952000102.22557.0.nnrp-14.c2de60da@news.demon.co.uk>...
>I am seeing exactly the same issue. My details are as follows :-
>
>Platform : Red Hat Linux 6.1 Kernel 2.2.12-20
>Engine : Informix Dynamic Server 2000 Version 9.20.UC1
>4gl : INFORMIX-4GL Version 7.30.UC1 Pcode Version 730
>
>The following code extract (and others) all compile but receive the same
>error when attempting to retrieve data. Either singleton selects or
cursors.
>
>MAIN
> DEFINE a char(1)
>
> DATABASE steve
>
> SELECT * INTO a FROM sw>
> DISPLAY a
>END MAIN
>
>( sw is a single column char(1) , single row table)
>
>All programs receive the following error message :-
>
>Program stopped at "sw.4gl", line number 6.
>4GL run-time error number -9971.
>Cannot determine the return types of a query or return types are
>inconsistent.
>
>If I remove the INTO clause and the DISPLAY. Then SQLCODE is set to 0 and
>the program completes.
>
>Does anyone have any ideas / suggestions
>
>Regards
>
>
>Steve Weet
>
>