Re: esql 5.0 to 7.12
Posted in 1997
David Williams — — source: Informix-list mailing list archive (1991-1998)
In article <33491A6E.149@ils.co.at>, Renate Groiss <rg@ils.co.at> writes
>we just ported our application from online 5.0 to 7.12,but it does not
>really work properly. the surprising thing is that the most simpe sql
>statements fail.
>for example:
>"EXEC SQL select count(*) into :cnt from any_table where id < 123"
>returns cnt 0 and sqlcode 0.
>dbaccess returns the proper value 2.
>
>anything known about the problem?
The datatype of count(*) has change from long to float....check
in the $INFORMIXDIR/release directory.
--
David Williams