I have the "Interbase 6 Data Definition Guide" and that is where DECLARE,
OPEN, FETCH, and CLOSE CURSOR is discussed. I just can't find anything
regarding them in Firebird 1.5. According to Carlos H. Cantu, I'll have to
wait until Firebird 2.0 before there is full CURSOR support. I already use
the FOR SELECT method, but I need to 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: "Thomas Steinmaurer" <ts@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, October 07, 2004 8:15 AM
Subject: RE: [firebird-support] DECLARE MyCursor CURSOR


>
> > 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?
>
> Robert, if you don't own the InterBase 6 Beta documentation set
> or one of the manuals available on the IBPhoenix CD, then get
> in touch with Firebird Stored Procedure and Triggers here:
> http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_intro_sp_trig
>
>
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database and MS SQL Server
> Upscene Productions
> http://www.upscene.com
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>