At 09:38 AM 30/07/2003 +0200, you wrote:

>How do I get the different rows of a selectable stored procedure using
>Delphi?
>
>When working with a query, I can go through the resulset step by step with:
>
>WHILE NOT Query.EOF
>Extract my data...
>Query.Next
>
>How is this done using an SP
>Is there an example available?

Just put the SP in a TIB_Query. Then it's just a dataset like any other.

sql:
select <output-field-list> from MySp( :param1, :param2)

Helen

>Florian
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/