--- In IBObjects@yahoogroups.com, "Scott Taylor" <scott@d...> 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,

Dear Scott, we are ALL terrible newbies.

because I

> can't get an error like the one you get. =P
>
> --
> Scott