Subject | Migration issues with a UDF function |
---|---|
Author | montgomery_list |
Post date | 2002-05-08T21:55:24Z |
Hi,
I have an existing UDF which was working fine under v4.2, and stopped
working fine after we migrated to Firebird.
The purpose of the function is this: if a column has a null value
return a floating point value of zero. (To avoid having a null SUM()
return value propigate)
Here is the UDF function in Delphi:
function DefZero(var Input: Double): Double;
begin
Result := Input;
end;
At this point, it is acting more like a random number generator than
anything else...
Is there any obvious fix for this?
Best Regards,
David Montgomery
I have an existing UDF which was working fine under v4.2, and stopped
working fine after we migrated to Firebird.
The purpose of the function is this: if a column has a null value
return a floating point value of zero. (To avoid having a null SUM()
return value propigate)
Here is the UDF function in Delphi:
function DefZero(var Input: Double): Double;
begin
Result := Input;
end;
At this point, it is acting more like a random number generator than
anything else...
Is there any obvious fix for this?
Best Regards,
David Montgomery