Subject | Re: [IBO] Resultset of a selectable procedure |
---|---|
Author | Lucas Franzen |
Post date | 2003-07-30T08:11:42Z |
Florian Hector schrieb:
SELECT * FROM MY_PROCEDURE ( :PARAM1, :PARAM2, ... )
That's it.
Selectable Procedures can be treated as regular tables, views, etc.
See above.
Luc.
> How do I get the different rows of a selectable stored procedure usingBy setting the appropriate SQL in the Query, like:
> 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
SELECT * FROM MY_PROCEDURE ( :PARAM1, :PARAM2, ... )
That's it.
Selectable Procedures can be treated as regular tables, views, etc.
>Non need for that.
> How is this done using an SP
> Is there an example available?
See above.
Luc.