Subject | FW: [ib-support] UDFs and NULL |
---|---|
Author | Gerhardus Geldenhuis |
Post date | 2001-09-17T12:38:27Z |
>Hi
>
> Is there a way to tell that a certain parameter passed to an UDF
> function is null?
>
> I need a function like NVL(<field>, <value>) which will return
> <value> if <field> is null and <field> itself if it isn't null...
>
> -- Dimitar
>
>
Here is a function I use in Delphi to check for null
procedure CheckVariables(var RF,WF:Integer);
begin
if VarIsNull(RF) then
RF:=0;
if VarIsNull(WF) then
WF:=0;
end;
Groete
Gerhardus