Hi, I am evaluating EDB and trying to do recursive function, but I always
got AV in doing it.

CREATE FUNCTION "Rekursi" (IN "Test" INTEGER)
RETURNS INTEGER
BEGIN
    DECLARE Result, i INTEGER DEFAULT 0;
    if test < 5 then

       SET i = test + 1;
       SET Result = Result + Rekursi(i);
    end if;
    RETURN Result;
END

Regards,


Surjanto

Surjanto,

<< Hi, I am evaluating EDB and trying to do recursive function, but I always
got AV in doing it. >>

Hmmm, I'm seeing a different bug with 2.03 Build 13 - it doesn't allow me to
define the function because it thinks that the Rekursi function doesn't
exist (which it doesn't, but it should allow this).

--
Tim Young
Elevate Software
www.elevatesoft.com

Sorry Tim,

Forgot to mention, I trick the SQL by not mentioning the function Rekursi at
creation, then alter and add it


Regards,


Surjanto

Surjanto,

<< Forgot to mention, I trick the SQL by not mentioning the function Rekursi
at creation, then alter and add it >>

Ahh, very clever.   I've reproduced the AV here, and I will have a fix
for it in the next build, which should be available by around Friday of this
week or Monday of next week.

--
Tim Young
Elevate Software
www.elevatesoft.com