Subject | Round() returning NULL |
---|---|
Author | sgharp |
Post date | 2004-10-05T20:06:43Z |
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
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