Subject Re: [ib-support] problem with built-in SQL function
Author Martijn Tonies

> 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
> 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

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

"This is an object-oriented system.
If we change anything, the users object."