Subject Re: Results of Executable Stored Procedures Called From DSQL?
Author inoffensive_2009
--- In firebird-support@yahoogroups.com, Milan Babuskov <milanb@...> wrote:
>
> Hello,
>
> This is more of a question for IBPP mailing list. Care to join:
>
> https://lists.sourceforge.net/mailman/listinfo/ibpp-discuss

Thanks Again Milan:

I do post to the IBPP list. Sometimes it's hard to tell which is more appropriate for a particular problem.

> inoffensive_2009 wrote:
> > 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.
>
> int result;
> st1->Get(1, result);

That works. I was attempting to use Fetch() before the Get.

As I've told you before, I appreciate the assistance you and so many in this group have given to me.

Thanks
Larry