At 01:24 PM 14/05/2003 +0000, you wrote:

>Hi Everyone,
>
>I get this message in relation to the function below, I have:
>
>checked the library exists and is readable
>checked the entry point exists
>stopped and started the firebird server
>
>any ideas please?
>
>DECLARE EXTERNAL FUNCTION UPPERFIRST
>CSTRING(256)
> RETURNS CHAR(256) FREE_IT
> ENTRY_POINT 'fn_upperfirst'
> MODULE_NAME '/opt/interbase/lib/udflib'

The path details don't belong there. Change it to 'MODULE_NAME 'udflib'
(and remember it's case-sensitive on Linux). In case you think that's a
dotty idea, consider the impact if you transported that database to another
platform...

If the library isn't located in the /UDF/ subdirectory (as appears to be
the case here) then either a) move it there or (preferred) make an entry
pointing to the location, in the config file isc_config (note the double
quotes and get the case right):

external_function_directory "/opt/interbase/lib"

You might also find that a symlink to it from /usr/lib might work.

In any case it's a fairly uncool idea to put your custom udf libs into
/opt/interbase/lib, 'cause they are likely to go AWOL if you upgrade.

heLen