Subject Re: [IBO] Error executing sp
Author Scott Taylor
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

--
Scott