Subject Re: [ib-support] Help with UDF!
Author Helen Borrie
At 05:59 PM 30-09-01 +0200, you wrote:
>Hi everybody!!
>
>I need help with this! I have the famous FreeUDFlib.dll, but i doesn't
>work!
>My questions are:
>Where the file must be?

You don't say what version of IB you are using nor which version of Windows!

If Firebird, move the dll into (root)\udf.
If another, try it in (root)\lib and (root)\bin. If it doesn't work in either of those places, put it into the Windows dir (Win9x, ME) or winnt\system32 (nt/w2k).

Date functions in FreeUDFLib won't work with a Dialect 3 database though. Take Hans' advice and use extract(year from fechaexptitulo) = 1964 with dialect 3.

rgds
Helen




>I Do this declaration:
>DECLARE EXTERNAL FUNCTION F_YEAR
>TIMESTAMP
>RETURNS INTEGER FREE_IT
>ENTRY_POINT 'year' MODULE_NAME 'freeudflib.dll';
>
>And appears on EXTERNAL FUNCTIONS, but when i Try to do:
>
> Select * from Abogado where f_year(fechaexptitulo) = 1964
>
>Exploids with this:
>
> "Invalid request BLR at offset 117
> function F_YEAR is not defined
> module name or entrypoint could not be found
> Statement: Select * from abogado where f_year(fechaexptitulo) =
>1964"
>
>What I'm doing wrong?
>
>
>Thanks a lot!
>
>=========================================================
>Hernan J. Galante
>Analista de Computacion - UNLP / Computer Analyst - UNLP
>www.hernangalante.com.ar
>---------------------------------------------------------
> Smalltalk - Linux - Interbase/Firebird are solutions!
>---------------------------------------------------------
>"The best Way to predict the future, is to invent it"
> by Alan Kay.-
>=========================================================
>
>
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @... address at http://mail.yahoo.com
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________