Roger Pullen wrote:

>
> Just testing an original IB6 db on RC2
>
> Has there been a change in integer datatypes?
>
> An SP which multiplied a numeric(9,2) by 10000
> and cast it as an integer now fails with an
> overflow. If I reduce the 10000 to 100 it is OK
>
> Works OK on real IB6
>

I've looked into this some more and I can't see where the problem might be.

Have you got a reproducable test case?


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further