Subject | declaration of abs (UDF) |
---|---|
Author | KURSAT TASKIN |
Post date | 2002-01-09T12:50:05Z |
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
thanks
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
thanks