Subject Re: Problem using UDF on Linux
Author Martha
Thanks heLen for replying..
It is a function to calculate 'multi' percentage of a given number.
Examples:
10+5+2% * 2500 = 405.25
--> 10% * 2500 = 250
--> 5% * (2500-250) = 112.5
--> 2% * (2500-250-112.5) = 42.75
--> 250+112.5+42.75 = 405.25 (the result)

As you can see, it has 2 input parameters: string value for the percentage
format, and numeric value for the number. My UDF is like this:

DECLARE EXTERNAL FUNCTION MYFUNC
CSTRING(64) CHARACTER SET NONE, DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'calc_percent' MODULE_NAME 'A2000UDF';

But since this error happened, I remarked all the codes in the source code
and simply just return 0 as the result. But the error persists.. :(

-MARTHA-


> Date: Tue, 01 Jun 2004 17:47:28 +1000
> From: Helen Borrie <helebor@...>
> Subject: Re: Problem using UDF on Linux
>
>This means that the server crashed when the client called the UDF. This is
>an alarm bell, even if a subsequent call to the same UDF succeeds. There's
>*something* happening out of sequence in the initialisation of that UDF code.
>
>The only wise thing to do under these circumstances is to compile the UDF
>as an application and test it thoroughly in Kylix, with tracing, to find
>out what you have there that is throwing an exception at initialisation.
>
>What sort of function is it?
>
>/heLen




==================================

Want to maximize Sales, get FAXtreme
Want to minimize Sales Effort, get FAXtreme
Want to learn more.....,
Contact (021) 5696 3765 or
Email to: sales@...

===================================