andrew_s_vaz wrote:

> As a test I inserted only whole numbers.

For those who hate to write themselves, here's the INSERT statement:

INSERT INTO ZZ_TESTE (FLD03, FLD04, FLD05, FLD06, FLD07, FLD08, FLD09,
FLD10, FLD11)
VALUES ( 123456789012, 123456789012, 12345678901,
12345678901234, 12345678901234, 123456789012345678,
12345678901234, 1234567890123, 123456789012);

> With IboConsole and SqlHammer it showed the correct numbers

I'm glad to report that FlameRobin does too. :)

>, then I tested with IbExpert personal and came up with this:
>
> FLD03 : 123456789012 - 123456789012,000015
> FLD10 : 1234567890123 - 1234567890123,000240
> FLD11 : 123456789012 - 123456789012,0000300
>
> At least with my tests this shows as a bug with numeric/decimal types
> with scales larger than 5, so It is something with IbExpert Personal
> (at least the version I have).

This looks like IBExpert uses float somewhere and looses the value in
character-to-decimal conversions. I have seen similar "rounding"
problems before.

--
Milan Babuskov
http://fbexport.sourceforge.net
http://www.flamerobin.org