Thanks. I'm able to use all the functions after running udf.sql.



--- In ib-support@yahoogroups.com, "Martijn Tonies" <m.tonies@u...>
wrote:

> Hi,
>
>
> > I tried Firebird 1.0 and 1.5 on my win2k PC. Everything works fine
> > except one major problem: it seems I can not run any built-in SQL
> > function such as rtrim(), strlen(), etc. Actually I can run none

of

> > the SQL function mentioned in the manual. Every time I get the

error

> > such as the following:
> >
> > Dynamic SQL Error
> > -SQL error code = -804
> > -Function unknown
> > -RTRIM
> >
> > Is there anything I missed? Thanks for your pointer.
>
> Yes - these aren't built-in functions. These are User Defined

Functions

> (UDFs). These UDFs are implemented in a shared library (dll on

Windows)

> and the functions need to be explicitly declared before you can use
> them.
>
> Check the docs on how - DECLARE EXTERNAL FUNCTION.
>
>
> With regards,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase & Firebird
> Firebird Workbench - the developer tool for Firebird
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."