--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> 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

The UDF is C:\Program Files\FireBird\UDF\fbudf.dll which is were
Firebird's install placed it. I don't know anything about
UDFAccess. I haven't seen anything in the stuff I've read that
talks about it. Also, I've been using the SUBSTRING function and
haven't declared it anywhere. Aren't they both in the same lib?

Steve