Subject | Re: Round() returning NULL |
---|---|
Author | sgharp |
Post date | 2004-10-05T22:15:53Z |
--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:
<Ivan.Prenosil@s...> wrote:
> > I'm using the Round() UDF from fbudf in a stored procedure andit's
> > returning NULL. I'm doing a select...into and setting a DoubleUDF,
> > Precision variable to 115.84. When I pass this variable to the
> > it returns NULL to the integer variable I'm assigning.parameters,
> >
> > dSales = 115.84;
> > iSales = Round(:dSales);
>
> Round() from fbudf does not support floating point input
> only exact numerics (integer, decimal, numeric).Perfect Ivan. Thanks much.
>