Thanks for your answer, but to which question are you answering?

Can one DECLARE, OPEN, FETCH, and CLOSE a CURSOR in one stored procedure?
If so, how? Using IBExpert, I can't seem to DECLARE a CURSOR, much less
OPEN, FETCH, and CLOSE it?

In Helen Borrie's book, she keeps saying that CURSORs are beyond the scope
of her book. Are CURSORs beyond the scope of Firebird too?

Regards,

Robert

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, October 07, 2004 7:46 AM
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,
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
SQL
> Server.
> Upscene Productions
> http://www.upscene.com
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>