I dont know if you saw my reply a few days ago but I get this same problem
when the .dll file is not present or is not loaded. It is also possible
that the dll is either corrupt or not developed correctly. There is an IB
Phoenix document that explains the search paths that IB looks in and how IB
works with UDF's, otherwise I would look at the dll code and see if there is
a problem. Can you post the dll code and the statement your are using to
declare the function in FB?

Branodn

-----Original Message-----
From: mk_delphi [mailto:mk_delphi@...]
Sent: Monday, June 03, 2002 6:35 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: How to use UDF in Firebird??


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

--- In ib-support@y..., Roland Turcan <rolo@s...> wrote:
> <<< 3. 6. 2002 8:58 - mk_delphi "mk_delphi@y..." >>>
> m> DECLARE EXTERNAL FUNCTION F_YEAR
> m> DATE
> m> RETURNS INTEGER BY VALUE
> m> ENTRY_POINT 'Year'
> m> MODULE_NAME 'c:\programmi\firebird\udf\FreeUDFLib.dll';
>
> In Firebird is implemented new function Extact for dates and times
> part extracting.
>
> Use this statement in SP:
>
> Year=Extract(Year from Date_Field);
>
> Or in Select:
>
> Select Extract(Year from Data_Field) from My_table;
>
> IMHO, external function for Year is useless.
>
> --
> Best regards, TRoland



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/