Subject Re: [IBO] Resultset of a selectable procedure
Author Lucas Franzen
Florian Hector schrieb:
> 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

By setting the appropriate SQL in the Query, like:

SELECT * FROM MY_PROCEDURE ( :PARAM1, :PARAM2, ... )

That's it.
Selectable Procedures can be treated as regular tables, views, etc.

>
> How is this done using an SP
> Is there an example available?

Non need for that.
See above.

Luc.