dr_bentonquest wrote:

> I'm working with Linux. The 'ib_udf' file is not a dll. My problem is
> that even when the file is in /opt/interbase/UDF and
> /opt/interbase/bin the entrypoint can't be found by firebird.

There is no TRIM function in ib_udf. You have ltrim and rtrim, but not
the trim itself. You can try what Alan suggested and use rFunc library.

Prehaps this can help (my setup):

root@saruman:/opt/interbase/UDF# ls -l
total 56
-rw-r----- 1 root root 12370 Mar 12 2002 ib_udf
-rw-r----- 1 root root 34449 Jun 14 2003 rfunc
-rw-r----- 1 root root 2414 Jun 14 2003 wangfunc

root@saruman:/opt/interbase/UDF# /opt/interbase/bin/isql /db/baza.gdb
SQL> show function trim;

Function TRIM:
Function library is rfunc
Entry point is fn_trim
Returns CSTRING(256) CHARACTER SET WIN1250
Argument 1: CSTRING(256) CHARACTER SET WIN1250


HTH

--
Milan Babuskov
http://fbexport.sourceforge.net