--- Blas Rodriguez Somoza <blas@...> wrote:
Hello

The test is very simple, if you run it you see 2
columns, one with numbers and another with letters,
with RC1 in front of number you see different letters
with RC2 you see every time the letter A.

The procedure is not intended to be used inside a
SELECT (not use SUSPEND but EXIT), it return only one
result. The different results are obtain by calling
the procedure after changing the parameter.

You have the source for SQL and Java in the zip file.

Regards

> 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
>
>
>
>

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com