Hi,

At November 15, 2003, 15:41, Helmut Steinberger wrote:

> I just wanted to say, that this problem is new. I used the same udf
> within the same programm (the same source) a few month ago and it
> worked well. I do not exactly know since when it doesn_t work. I
> updated to FB 1.5 in the last time, and maybe that causes the problem.

> Today I changed the udf in that way, that I reoderd the parameters.
> Putting the dateparamter on first place, then the problem disapeared.
> For that is a possible workaround, I am not satisfied with that,
> becaus I have more udfs, which have date typed parameters, and I
> don't like to reorder all of them.

> Does anybody has any idea, what is going wrong there?

This could be related to the parameter ordering in Firebird 1.5. Did
you download the latest version of IBO(version 4.3)? It's supposed to
fix that problem.

What happens is that the parameter ordering bug(which was a long
standing issue) has been fixed in Firebird 1.5, but IBO has some code
that is a work-around for the bug. And when the bug got fixed, it
meant that the work-around causes problems. IBO 4.3 has the ability to
recognize the parameter ordering that the server is using.

Hope this helps.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)