Subject Re: [firebird-support] Problem using FreeUDFLib
Author Ivan Prenosil
> I downloaded FreeUDFLib from IBPhoenix, but I'm having problem on
> trying to use it.
>
> I do the following:
>
> - Copy FreeUDFLib.dll to %Firebird_Install_Dir%\UDF (there already are
> fbudf.dll and ib_udf.dll)
>
> - Run the following declaration in IBExpert, with a database opened:
> declare external function f_AgeInMonths
> date, date
> returns
> integer by value
> entry_point 'AgeInMonths' module_name 'FreeUDFLib';
>
> - Commit
>
> - And, there is it on UDF List.
>
> OK
>
> But, when I run this sql in IBExpert I got an error message:
>
> select f_ageinmonths(data_aprovado, current_date) from propostas
>
> Invalid token.
> invalid request BLR at offset 60.
> function F_AGEINMONTHS is not defined.
> module name or entrypoint could not be found.

The library is linked to old gds32.dll (because of isc_encode_date, isc_decode_date).
You can let FB installer create that library for you, or you can just
copy fbclient.dll into UDF/gds32.dll

Ivan
http://www.volny.cz/iprenosil/interbase/