Subject | Re: [firebird-support] Round() returning NULL |
---|---|
Author | Ivan Prenosil |
Post date | 2004-10-05T20:23:37Z |
> I'm using the Round() UDF from fbudf in a stored procedure and it'sRound() from fbudf does not support floating point input parameters,
> returning NULL. I'm doing a select...into and setting a Double
> Precision variable to 115.84. When I pass this variable to the UDF,
> it returns NULL to the integer variable I'm assigning.
>
> dSales = 115.84;
> iSales = Round(:dSales);
only exact numerics (integer, decimal, numeric).
Ivan