Re: 4GL run-time error number -9971.
Problem solved:
Informix Tech Support says there is a bug in 4gl RDS/ID 7.30.
Service-Packs, sorry, Patches can be downloaded under ftp1.informix.com
Rolf Roth wrote:
> I have the following Informix environment on our SUN 3500 with Solaris
> 2.6:
> - INFORMIX-4GL Version 7.30.UC3
> Pcode Version 730 RDS/ID
> - Informix Dynamic Server 2000 Version 9.20.UC3
> Now to the problem:
> select * from ... is working fine with dbaccess.> insert into ... is working fine with I4GL and dbaccess.
> But when I try a "Prepare a_curs cursor for select * from .... Foreach
> ..... end foreach" or ""select count(*) into ... from ..." I get an
> error:
> Program stopped at "test1.4gl", line number 10.
> 4GL run-time error number -9971.
> Cannot determine the return types of a query or return types are
> inconsistent.
>
> The test.4gl-Code is:
> database db1
> main
> define
> p_tab1 record like tab1.*,
> cnt integer
>
> display "start" at 1,1
> declare a_curs cursor for
> select * from tab1;> foreach a_curs into p_tab1.*
> end foreach
> display "end" at 11,1
> end main
>
> The 4GL-Code has been compiled in the same environment. All selects
> produce this error, inserts are working fine !?
> Does anyone have an idea ???
>
> Thanks in advance
> Rolf Roth