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