Thank you. It solved the first step.

I'm used to Sybase AnyWhere and it along with the Enterprise has a built in
cursor so there I don't have to think 'dBase'. Nothing wrong with that. Just
different.

Are you ready for next step?

Best regards John.

On Friday 29 April 2005 20:08, Martijn Tonies wrote:
> > 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?
> >
> > CREATE PROCEDURE SEL_PROC_V_PRESENTASJON (
> > IN_KAT VARCHAR (100))
> > RETURNS (
> > V_ID_KATEGORI INTEGER,
> > V_KATEGORI VARCHAR (100),
> > V_ID_LEVERANDOR INTEGER,
> > V_LEVERANDOR VARCHAR (100),
> > V_URL VARCHAR (254),
> > V_KALKURL VARCHAR (254),
> > KAT_CNT INTEGER)
> > AS
> > BEGIN
>
> FOR SELECT ... -> will start a loop
>
> > select ID_KATEGORI, KATEGORI, ID_LEVERANDOR,
> > LEVERANDOR, URL, KALKURL
> > from view_presentasjon
> > where kategori like :in_kat
> > order by kategori into
> >
> > :V_ID_KATEGORI, :V_KATEGORI, :V_ID_LEVERANDOR,
> > :V_LEVERANDOR, :V_URL,:V_KALKURL;
> >
> > suspend;
>
> DO SUSPEND;
>
> -> DO <something in the loop>
>
> > END
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
>
>
>
>
> Yahoo! Groups Links
>
>
>

--