Hi,
Counting with for .. do was the solution. It works fine. Thank you Michael.

Walter

Am Montag, 10. Februar 2003 15:29 schrieb Andrew Guts:

> Michael Vilhelmsen wrote:
> >Hi
> >
> >Is it posible to have a stored procedure return a dataset ?
> >
> >A simpel ex. could be Select * from MyTable
> >
> >which should return 20 records.
> >
> >Michael
>
> set term ^ ;
> create procedure spResultSet(K char(50))
> returns (NN integer, F1 integer, F2 char(50)) as
> begin
> NN = 1;
> for select first 20 Field1, Field2 from MyTable
> where Field2 like :K into :F1, :F2
> do begin
> suspend;
> NN = NN+1;
> end
> end^
> set term ; ^
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/