Subject | Re: [firebird-support] ABS() UDF in FB 1.03? |
---|---|
Author | Helen Borrie |
Post date | 2004-06-22T00:04:27Z |
At 11:00 PM 21/06/2004 +0000, you wrote:
2. What is your UDFAccess setting in firebird.conf?
/heLen
>Hi All,1. Where is your udflib located?
>
>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,
2. What is your UDFAccess setting in firebird.conf?
/heLen