Subject Re: [firebird-support] Round() returning NULL
Author Ivan Prenosil
> I'm using the Round() UDF from fbudf in a stored procedure and it's
> 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);

Round() from fbudf does not support floating point input parameters,
only exact numerics (integer, decimal, numeric).

Ivan