Subject | Re: [firebird-support] Problem using FreeUDFLib |
---|---|
Author | Ivan Prenosil |
Post date | 2006-05-25T14:11:52Z |
> I downloaded FreeUDFLib from IBPhoenix, but I'm having problem onThe library is linked to old gds32.dll (because of isc_encode_date, isc_decode_date).
> 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.
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/