--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:

>
> At 08:16 PM 12/10/2007, you wrote:
>
> > >
> > > Explicit CURSORS in FB2's PSQL may help you
> >
> >I think they will. Thanks!
>
> You can use explicit cursors in Fb 1.5 as well. The syntax is a

bit

> different...
>
> If you haven't sussed out already how you're going to do this,

I'll

> try to help you out over the weekend...not today though...to much
> else going on that can't wait.
>
> ./heLen
>

Thanks, but I think I'm good now and am rather looking forward to
doing this. In the middle of the night I realized that the thing
that was bothering me was that cursors apparently had to be
anonymous, and since I had to have access to either of two cursors
on an arbitrary basis, I didn't quite see how the overlapping scopes
could be made to work.

But I also concluded that there was probably a way to declare a
cursor (in languages that support anonymous classes, this would be
the more common occurrence, and ISTM that there ought to be such a
thing here as well). So when I got up, I started looking into that
and had just gone from your book to the FB 2 release notes when
Vlad's message arrived.

This will be my first (non-trivial) SP. I've seen SP debuggers
mentioned in this group. What do most people use?

And thanks again to you, Helen, and to Vlad for helping me out.

Michael D. Spence
Mockingbird Data Systems, Inc.