Subject RE: [IBO] Stored proc question
Author Helen Borrie
At 11:30 PM 29-05-01 +1000, I wrote:
>At 03:05 PM 29-05-01 +0200, you wrote:
> >Helen,
> >
> > One more thing, it's a procedure that is returning a value, is ExecProc
> >the preferred way to get the value ? Should I get that value through a
> >IB_Cursor ? It's just a one-record select I'm doing.
>Well, you >can< do it (and, I think, solve the bug, too, i.e. avoid having to unprepare) by adding a SUSPEND to your stored procedure and using a SELECT from the SP to both execute it and get the return value.

I should have said "using a TIB_Cursor instead of a TIB_StoredProc".


All for Open and Open for All
InterBase Developer Initiative ยท