Re: esql 5.0 to 7.12
In <7ELpKOAZBqTzEwrK@smooth1.demon.co.uk>, David Williams wrote:
}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.
This change will affect the program, only when count(*) returns a number
bigger than MAX size for integers, which is 2.1+ billion, other wise it
should work fine.
So Renate, your problem needs further digging/debugging.
Good Luck
Felix K. Mathews