Subject Re: Round() returning NULL
Author sgharp
--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:
> > 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).
>
Perfect Ivan. Thanks much.