At 04:14 PM 2/09/2004 -0700, you wrote:

>Hi folks,
>
>I was trying to use some functions as simple as ASB() or CIELING() in the
>sql statement, but firebird returned me the following error, why?
>
>Dynamic SQL Error
>-SQL error code = -804
>-Function unknown
>-ABS
>
>Dynamic SQL Error
>-SQL error code = -804
>-Function unknown
>-CEILING
>
>Thanks in advance!

Any external functions you want to use must be declared to the database, e.g.

DECLARE EXTERNAL FUNCTION abs
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'ib_udf';

You can find all the declarations in the *.sql files in the /UDF directory.

./heLen