--- In firebird-support@yahoogroups.com, "Alberto Pesce"
<palberto@l...> wrote:

> Hi all,
>
> Why if I submit value like 323,3 to a store procedure I obtain in

table the value 323,29998

>

numeric (15,5) <> float

PS: if you want a value "extacly" use always numeric(x,y)

> like:
>
> PROCEDURE NEW_PROC (float input, .....)
> begin
> ....
>
> INSERT INTO TABLE PROVA (enter,.....) VALUE (input,....)
>
> /* note in table prova field 'enter' is a numeric (15,5) */
>
> ....
> end
>
> I don't understand why?

declare your procedure like

PROCEDURE NEW_PROC (NUMERIC(15,5) input, .....)

> Thanks to all
> Alberto
>

PS: wow un altro italiano :-D

>
>
> ____________________________________________________________
> Navighi a 4 MEGA e i primi 3 mesi sono GRATIS.
> Scegli Libero Adsl Flat senza limiti su http://www.libero.it