Subject Re: [firebird-support] How to declare UDF ?
Author Dmitry Yemanov
Vince Ieraci wrote:
>
> I have FB installed on OpenSUSE 10.2.
> I want to declare some UDF's from the /opt/firebird/UDF/fbudf.so
> shared library.
>
> Question is how do I declare the functions in FB ?
> I tried copying some text from the .sql file and running it in a
> command window (FlameRobin)
>
> DECLARE EXTERNAL FUNCTION lower
> CSTRING(255)
> RETURNS CSTRING(255) FREE_IT
> ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf';
>
> but I get the error message "Token Unknown" which is referring to
> "lower".

LOWER is a built-in function since Firebird 2.0. You don't need to use a
UDF based implementation.


Dmitry