Carlos,

When it is implemented, will I be able to put the DECLARE, OPEN in one
stored procedure, the FETCH in another stored procedure, and CLOSE in yet
another? Something I should be able to do since the named CURSOR remains
live until specifically CLOSEd.

Regards,

Robert

----- Original Message -----
From: "Carlos H. Cantu" <listas@...>
To: "Robert Meyer" <firebird-support@yahoogroups.com>
Sent: Thursday, October 07, 2004 8:06 AM
Subject: Re: [firebird-support] DECLARE MyCursor CURSOR


>
> The only currently way to use cursors in SPs and Triggers is the FOR
> SELECT statement.
>
> In FB 2.0, full cursor support will be available inside SP's and
> Triggers.
>
> Carlos
> http://www.warmboot.com.br
> FireBase - http://www.FireBase.com.br
>
>
> RM> Thanks for your answer, but to which question are you answering?
>
> RM> Can one DECLARE, OPEN, FETCH, and CLOSE a CURSOR in one stored
procedure?
> RM> If so, how? Using IBExpert, I can't seem to DECLARE a CURSOR, much
less
> RM> OPEN, FETCH, and CLOSE it?
>
> RM> In Helen Borrie's book, she keeps saying that CURSORs are beyond the
scope
> RM> of her book. Are CURSORs beyond the scope of Firebird too?
>
> RM> Regards,
>
> RM> Robert
>
> RM> ----- Original Message -----
> RM> From: "Martijn Tonies" <m.tonies@...>
> RM> To: <firebird-support@yahoogroups.com>
> RM> Sent: Thursday, October 07, 2004 7:46 AM
> RM> Subject: Re: [firebird-support] DECLARE MyCursor CURSOR
>
>
> >>
> >> Hi,
> >>
> >> > Does "DECLARE MyCursor CURSOR" not work in Firebird 1.5?
> >> >
> >> > I am trying to declare a cursor and open it in one stored procedure,
> RM> then
> >> fetch in another stored procedure, then close in yet another stored
> >> procedure. Is this not possible?
> >> >
> >>
> >> Nope.
> >>
> >> With regards,
> >>
> >> Martijn Tonies
> >> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
> RM> SQL
> >> Server.
> >> Upscene Productions
> >> http://www.upscene.com
> >>
> >>
> >>
> >>
> >>
> >> Yahoo! Groups Links
> >>
> >>
> >>
> >>
> >>
> >>
> >>
>
>
>
>
>
> RM> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>