Subject Re: [firebird-support] Getting UDFs to work
Author Helen Borrie
At 10:11 PM 5/04/2004 +0000, you wrote:
>I wanted to get the standard UDF's shipped with FB to work. In my
>firebird.conf file, I removed the '#' in the line that allows UDFs to
>work in restricted mode, making it appear:
>
>UdfAccess = Restrict UDF
>
>But when I try to compile my script it tells me that 'COS' is not a
>function (in IB Workbench).
>
>How do I get the UDFs to work in FB? (Haven't worked with them
>before).

You have to declare the function to the database. You can copy/paste the
declaration from ib_udf.sql, viz.

DECLARE EXTERNAL FUNCTION cos
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_cos' MODULE_NAME 'ib_udf';
COMMIT; /* !!!!!!!!!!!! */

/heLen