sgharp wrote:

>--- 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
>
>
>

Steve,

Substring are a Built-in function now


see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br