FWIW, I made a small database with FB 1.5.2.4731, dialect 3 with this
DDL

CREATE TABLE ZZ_TESTE (
ID01 SMALLINT ,
FLD01 INTEGER ,
FLD02 VARCHAR(14),
FLD03 DECIMAL(18,6),
FLD04 DECIMAL(12,0),
FLD05 DECIMAL(12,2) DEFAULT 0,
FLD06 DECIMAL(14,4) DEFAULT 0,
FLD07 NUMERIC(14,4),
FLD08 NUMERIC(18,0),
FLD09 NUMERIC(14,5),
FLD10 NUMERIC(14,6),
FLD11 NUMERIC(14,7),
FLD12 SMALLINT
);

As a test I inserted only whole numbers.

With IboConsole and SqlHammer it showed the correct numbers, then I
tested with IbExpert personal and came up with this:

Field : Inserted - Shown
FLD03 : 123456789012 - 123456789012,000015
FLD04 : 123456789012 - 123456789012
FLD05 : 12345678901 - 12345678901
FLD06 : 12345678901234 - 12345678901234,0000
FLD07 : 12345678901234 - 12345678901234,0000
FLD08 : 123456789012345678 - 123456789012345678
FLD09 : 12345678901234 - 12345678901234,00000
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).

Maybe you should contact the guys from IbExpert to see about this.

HTH
Andrew

>
> I already have a dialect 3 database with FB 1.5.2.
>
> Luis
>
> Martijn Tonies wrote:
>
> >Hi,
> >
>