Re: udf

Sergio Gonzalez wrote:

> Hello! I've declared a new function:
> 
> DECLARE EXTERNAL FUNCTION CEILING
>    DOUBLE PRECISION
>    RETURNS DOUBLE PRECISION BY VALUE
>    ENTRY_POINT 'IB_UDF_ceiling' MODULE_NAME 'ib_udf';
> 
> when I try to test it with
> 
> CREATE PROCEDURE NEW_PROCEDURE
> AS
> declare variable VALOR INTEGER;
> BEGIN
>  VALOR = ceiling(12.43);
> END
> 
> I get an error. It says that the module_name or the entry_point
> couldn't be found.
> 
> Thanks for any help!
> 
> -sergio


You're calling "ceiling", but you haven't defined a function named
"ceiling".


-- 

Sergio Gonzalez wrote:

> Hello! I've declared a new function:
> 
> DECLARE EXTERNAL FUNCTION CEILING
>    DOUBLE PRECISION
>    RETURNS DOUBLE PRECISION BY VALUE
>    ENTRY_POINT 'IB_UDF_ceiling' MODULE_NAME 'ib_udf';

	Where is the DLL (path) and which version of IB are you using? Is it
IB on Windows?

-- 
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
IB 6 versions prior to 6.0.1.6 are pre-release and may corrupt 

Patrick Moloney wrote:

> You're calling "ceiling", but you haven't defined a function
named
> "ceiling".

	Huh?

> > DECLARE EXTERNAL FUNCTION CEILING

-- 
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
IB 6 versions prior to 6.0.1.6 are pre-release and may corrupt 

	If Firebird 1.5 behaves like IB 6 in this respect (I have no idea)
then the DLL needs to be in /UDF, not in /bin.

-- 
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Please read and follow Borland's rules for the user of their 

I think it was InterBase 7 not 6 where UDF's had to be the UDF dir....

Craig Stuntz [TeamB] wrote:
> 	If Firebird 1.5 behaves like IB 6 in this respect (I have no idea)
> then the DLL needs to be in /UDF, not in /bin.