You'v to select 1 record into procedures, using select first 1 from
xxxxx or use a bucle.
You can not extract more then one record from a select.
regards
Fer

On 4/29/05, Mark Bracey <markbracey@...> wrote:
> Hopefully this is assumed to still be on topic. Can anyone recommend a good
> book on creating views/stored procedures?
>
> Subject: Re: [firebird-support] Multiple select inside procedures???
>
> > I'm trying to figure out how to get a procedure to return more than one
> row. I
> > know that this procedure does not work because it is supposed to return
> > multiple rows and this one can't. So - how is it to be re-written som it
> > works?
> >
>
>
> [Non-text portions of this message have been removed]
>
> Yahoo! Groups Links
>
>
>
>
>


--
Ing (Eng) Fernando J. Buitrago Clausell
Cell: 809-805-8343
Tel : 809-274-5353
CUBA y Republica Dominicana