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/
_______________________________________________________