Hi,

Thanks Andrew,

In fact I do use IBExpert and FIBPlus/D2005 Pro.
And I saw this behavior in IBExpert, have to test it in my app too.
I also have a demo of SQLHammer, so I will check with the same DB.

I will send a bug report to IBExpert people.


Regards,


Luis Madaleno



andrew_s_vaz wrote:

>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,
>>>
>>>
>>>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>