At 08:04 AM 5/06/2004 -0700, you wrote:

>constantijnw said:
> > --- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
>
>I think what Alan is tryint to tell you, is you are using it all wrong.
>
>your SP needs to suspend in order to work properly:
>
>CREATE PROCEDURE SP_3
>RETURNS ( ACCOUNTID INTEGER )
>AS
>BEGIN
> ACCOUNTID = 1;
> SUSPEND;
>END
>
>Then to see the output you need to select it:
>
>SELECT * from SP_3
>
>You didn't get any value returned by IB_Cursor because you didn't SUSPEND
>after the assignment.
>
>But I'm just a lerking newbie, I'm probably missing something, because I
>can't get an error like the one you get. =P

You're also fairly off-beam about this. You *can* convert it to a
selectable SP and call it into an ib_cursor with SELECT - but it's much
more optimal to leave it as an executable SP and call it into ib_cursor (or
ib_dsql) with Execute.

When you call Open or First on an executed statement, you get cursor errors.

Helen