Subject Round() returning NULL
Author sgharp
Hi All,

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);

What am I doing wrong?

The UDF is declared as:
declare external function Round
int by descriptor, int by descriptor
returns parameter 2
entry_point 'fbround' module_name 'fbudf';

Thanks,
Steve