Subject Re: [firebird-support] Re: NUMERIC(18,6) PRECISION
Author Martijn Tonies
> > 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. :)

So does Database Workbench :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com