----- Original Message -----

From: Roman Rokytskyy

To: Firebird-Java@yahoogroups.com

Sent: Saturday, August 30, 2003 8:55 AM

Subject: [Firebird-Java] Re: ResulSet not follow

> cs = con.prepareCall("{call OBTENER_TIPOS_ID}");

Replace this with:

cs = con.prepareCall("SELECT * FROM OBTENER_TIPOS_ID");

> When I run, only show the first row and exists from the while loop.
>
> What happen?

{call ....} is translated into EXECUTE PROCEDURE .., and this SQL
statement returns only one result. For selectable procedures you have
to use SELECT statement.

Best regards,
Roman Rokytskyy



To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.