Heck yeah!

Use the 'FOR SELECT' method...
(Don't forget to change the terminator to something different when making
Stored Procedures)


SET TERM !! ;

FOR SELECT field1, field2, field3
FROM my_table_of_stuff
INTO :output1, :output2, :output3
DO
BEGIN
/* Process your data if you need to - good for reports, etc */

/* Output the data with a SUSPEND */
SUSPEND;
END !!

SET TERM ; !!

> -----Original Message-----
> From: Yosvany Llerena Rodríguez [mailto:yerena@...]
> Sent: Monday, 8 December 2003 09:27
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] SP more than one row
>
>
> Hello every body.
>
> I'm a beginner with FB-IB.
>
> my question is:
> Can any Stored Procedure return more than one row?.
>
>
> Thanks in advanced.
> Yosvany.
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Buy Ink Cartridges or Refill Kits
> for your HP, Epson, Canon or Lexmark Printer at MyInks.com.
> Free s/h on orders $50 or more to the US & Canada.

http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/67folB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/