Subject | Re: How to use UDF in Firebird?? |
---|---|
Author | csswa |
Post date | 2002-06-02T08:29:42Z |
> DECLARE EXTERNAL FUNCTION F_YEARFor module name, try the file name without the .dll,
> DATE
> RETURNS INTEGER BY VALUE
> ENTRY_POINT 'Year'
> MODULE_NAME 'c:\programmi\firebird\udf\FreeUDFLib.dll';
e.g. 'freeudflib' -- and ensure all your udf dlls go in the 'UDF'
folder off your server installation path.
Regards,
Andrew Ferguson
-- All tongue and no sandwich.
--- In ib-support@y..., "mk_delphi" <mk_delphi@y...> wrote:
> Hi all,
> I am not able tu sue UDF in my firebird 1.0,
> i try to use FreeUDFLib:
>
> I declared the function I need like:
>
> DECLARE EXTERNAL FUNCTION F_YEAR
> DATE
> RETURNS INTEGER BY VALUE
> ENTRY_POINT 'Year'
> MODULE_NAME 'c:\programmi\firebird\udf\FreeUDFLib.dll';
>
> or without the path, but they want work;
>
> calling this:
> select f_year(data_ordine) from ordini_cli_a
> i get:
> invalid token.
> invalid request BLR at offset 60.
> function F_YEAR is not defined.
> module name or entrypoint could not be found.
>
> Can someone help me?
> I copied FreeUDFLib.dll everywhere in my PC..
> Best regards