Hello Robert,

> 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

Not for procedural SQL. These are all about "embedded SQL".

> 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.

Well, currently, you cannot.

And having a cursor across procedure boundaries might be a different
story altogether.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com