Subject | ABS() UDF in FB 1.03? |
---|---|
Author | sgharp |
Post date | 2004-06-21T23:00:05Z |
Hi All,
I've declared the ABS() UDF in my database as so.
DECLARE EXTERNAL FUNCTION abs
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'fn_abs' MODULE_NAME 'udflib';
The database accepts this and IBExpert shows ABS() as one part of
the database. However, when I try to use ABS() in a stored
procedure, if barfs after the compile with this message.
Invalid token.
invalid request BLR at offset 526.
function ABS is not defined.
module name or entrypoint could not be found.
What could I be doing wrong? My usage syntax is something like.
nTar = ABS(nSrc);
Thanks for any help,
Steve
I've declared the ABS() UDF in my database as so.
DECLARE EXTERNAL FUNCTION abs
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'fn_abs' MODULE_NAME 'udflib';
The database accepts this and IBExpert shows ABS() as one part of
the database. However, when I try to use ABS() in a stored
procedure, if barfs after the compile with this message.
Invalid token.
invalid request BLR at offset 526.
function ABS is not defined.
module name or entrypoint could not be found.
What could I be doing wrong? My usage syntax is something like.
nTar = ABS(nSrc);
Thanks for any help,
Steve