Subject Re: [firebird-support] ABS() UDF in FB 1.03?
Author Helen Borrie
At 11:00 PM 21/06/2004 +0000, you wrote:
>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,

1. Where is your udflib located?
2. What is your UDFAccess setting in firebird.conf?

/heLen