Thats great, thanks :)

--- "Alexander V.Nevsky" <ded@...> wrote: >
--- In firebird-support@yahoogroups.com,

> "NextStepSolutions"
> <nextstepsolutions@y...> wrote:
> > SET TERM !!;
> > CREATE PROCEDURE getnames
> > RETURNS (title VARCHAR(10), forename VARCHAR(30),
> surname
> VARCHAR(30)) AS
> > BEGIN
> > FOR SELECT title, forename, surname
> > FROM name
> > INTO :title, :forename, :surname
> > DO BEGIN
> > SUSPEND;
> > END
> > END !!
> > SET TERM ;!!
> >
> >
> > This is recognised as a valid stored procedure by
> iSql, but only
> > returns one row.
> > I was hoping to get all rows from the table - is
> it SUSPEND that is
> > causing it to stop after just one row?
>
> No, it was Andy, who performed "Execute Procedure
> getnames" instead
> of "Select * From Procedure getnames" ;)
>
> Best regards,
> Alexander.
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
>
> Yahoo! Groups Links
>
>
> firebird-support-unsubscribe@yahoogroups.com
>
>
>

___________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html