At 02:50 PM 09-01-02 +0200, KURSAT TASKIN wrote:

>Hi
>I have a problem with UDF, I want to use ABS in a wiew.
>Declaration of external function ABS is following
>
>DECLARE EXTERNAL FUNCTION ABS
> DOUBLE PRECISION
> RETURNS DOUBLE PRECISION BY VALUE
> ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'fbudf.dll'
>
>the declaration of wiew is following
>CREATE VIEW AVG_YAKIN
>(
> HISSE,
> YAKIN
>) AS
>SELECT HISSE,C_AVG_PD FROM DATA WHERE ABS(C_AVG_PD)>0 ;
>
>
>but I could not create view it gives an error "ABS is not defined, module
>name or etrypoint could not be found
>I am using latest version of Firebird

Kursat,

This UDF is not in fbudf.dll, it is in ib_udf.dll. Also, don't include ".dll" in the module_name as you will cause your database to be not transportable.

Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________