Thanks Alex,

I left IBX behind a long time ago after the whole IB split thing.
Working on Carlo's .net provider and C# now - works great!

Was just making sure it wouldn't effect this new client platform.

Thanks,

John

--- In firebird-support@yahoogroups.com, "Alexander V.Nevsky"
<ded@h...> wrote:

> --- In firebird-support@yahoogroups.com, "johnsparrowuk"
> <jsparrow@e...> wrote:
> > Back in the days of IB6 beta and IBX (around yr 2000), you

weren't

> > supposed to use executable (as opposed to selectable) sprocs

because

> > of some bug that caused them to occasionally fail (in ibclient??)
> >
> > Is this fixed now?
>
> John, in FB's gds32 (fbclient now) it was fixed by Ann in November
> 2001. What about modern IBX... Check TIBSQL.ExecQuery in ibsql.pas,
> and if SQLExecProcedure: part of Case still contains idiotic
> workaraund (repeat of call in case of exception, which can corrupt

you

> data if SP makes inserts or incremental updates), change it to

simple

>
> SQLExecProcedure:
> begin
> fetch_res := Call(isc_dsql_execute2(StatusVector, TRHandle,

@FHandle,

> Database.SQLDialect,
> FSQLParams.AsXSQLDA,
> FSQLRecord.AsXSQLDA),

True);

> end;
>
> Best regards,
> Alexander.