Subject Re: [IBO] TIB_Script
Author Lester Caine
Shaq wrote:
> I am creating a TIB_Script object dynamically. Then generating the sql
> for the script. When I launch the script it will report an update
> conflict (which would happen sometimes in my situation). An exception
> occurs and the transaction is rolled back. I am controlling the
> transactions myself.
> The problem is that part of the script prior to the deadlock always
> gets processed. I am not sure why since I call the rollback.
> I know that I am probably missing some kind of setting or something
> but I can't figure out what it is.

We probably need more info.
If you have the TIB_Script 'inside' a transaction, then it should not be
possible for it to commit - unless you call commit.
The settings for auto commit may be kicking in, 'ServerAutoCommit' in
particular, so are you calling StartTransaction before the script?
What point in the script does it commit to?

Lester Caine
L.S.Caine Electronic Services