Hi Again Folks:

Developing on XP Home, VS2008 Pro, C++, Firebird 2.1.1.17910-0
SuperServer, ibpp-2-5-3-1.

I was called away from my effort to learn about procedures and triggers for a couple of days, but I'm back on it now.

I don't understand what I do to get the result of an executable stored procedure. IBPP's

st->Prepare(sql_string.c_str());
st->Execute();

statements are are quite happy to run

EXECUTE PROCEDURE IS_PORK_SAFE('2009-01-01')

but I don't know how to see the result.

I did add a "SUSPEND;" in front of the last "END;" in Helen's sample and SELECT works fine, and I can use IBPP's st->Fetch() to extract the appropriate result.

How do I get the result of an executable stored procedure?

Thanks
Larry