Thomas,

As I understand it, with newer versions of Firebird you can't get a record
out of it without a call to SUSPEND regardless of what API call you use.

TIB_DSQL won't do anything better than the TIB_StoredProc.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Thomas Steinmaurer
Sent: 09 January 2012 01:11 AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] 4.9.14b32 - Problem with executable SP and output
parameters

Hi Jason,

> The reason it will have appeared to work is because there was also a time
> when there was a bug in the API call and so in order to work around that

bug

> I didn't use the isc_dsql_execute2() API call. I actually used the
> isc_dsql_execute() API call which required me to open a cursor, fetch one
> record, and then close the cursor.

Ok, then how do I execute an executable stored procedure without a
SUSPEND in the body and returning output parameter values? Obviously I
can't do that anymore with a TIB_StoredProc and the ExecProc call.

With a TIB_DSQL?

Thanks,
Thomas

> So, the waters are considerably murky.
>
> Jason
>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On

Behalf

> Of Thomas Steinmaurer
> Sent: 09 January 2012 12:48 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] 4.9.14b32 - Problem with executable SP and output
> parameters
>
> Hello Jason,
>
>> The change took place in Firebird, not IBO.
>
> Hmm. I was trying an older IB LogManager version with Firebird 2.5 where
> it worked. Recompiled IBLM with the most recent IBO version against
> Firebird 2.5 shows the problem, so it isn't a pure Firebird engine

problem.

>
> Regards,
> Thomas