Hello


At 14/01/2003 02:04 -0800, Engine Ehs wrote:

>--- Blas Rodriguez Somoza <blas@...> wrote:
>Hello
>
>I send to you a test program (a modified version of
>varchar test) : with RC1 the first test fail and the
>second pass, with RC2 the first pass but the second
>fail.

Thanks for the test, but I try with your program and I don't know what it must return, so I prepare an internal test to test the issue.

I verify that the prepareCall("{ call ...}"); return only one line.

According to the IB6 docs (Data Def guide), an executable procedure can be called with "select .. from ...." or "execute procedure" but a select procedure must be called with "select .. from ... " if you want to get all the lines. Execute procedure seems to return only the first line if there are more than one (IB6 Data definition guide 157)

{call ..} is translated to EXECUTE PROCEDURE by the driver, so it must only return the first line.

Please try with the select method.

I don't know why a previous version return more than one line but according with what you say about a RC1a error corrected now I suspect the two are related.

Regards
Blas Rodriguez Somoza