Thanx Helen...
I dont know why but now work....
I am not able to figure out where I made mistakes....
...

--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> At 10:34 PM 03-06-02 +0000, you wrote:
> >I know about Extract but the fact is I am nota able
> >to use UDF!!!
> >The UDF is the standard FreeUDFLib from C.Valde,
> >The firebird is the last...
> >So why want work? damn
>
> Do this:
>
> 1. Drop the declaration that you have in your database and commit
work.
> 2. Disconnect from the database and shut down the server.
> 3. Copy the dll into your ..\Firebird\UDF directory.
> 4. Open ibconfig and check that you don't have a "live" entry for
> EXTERNAL_FUNCTION_DIRECTORY or that, if you do, it is correctly
pointing to
> your UDF directory.
> 5. Start up the server again and log in as SYSDBA.
> 6. Redeclare the UDF as follows:
>
> DECLARE EXTERNAL FUNCTION F_YEAR
> DATE
> RETURNS INTEGER BY VALUE
> ENTRY_POINT 'Year'
> MODULE_NAME 'FreeUDFLib';
>
> All this assumes, of course, that your Firebird server is running
on
> Windows. FreeUDFLib.dll works only on a Windows server.
>
> heLen
>
>
> All for Open and Open for All
> Firebird Open SQL Database · http://firebirdsql.org ·
> http://users.tpg.com.au/helebor/
> _______________________________________________________