At 06:16 AM 7/04/2005 +0000, you 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.

Do you perhaps have the script bound to an autocommit transaction? In that
case, rollback would apply only to the current statement, since previous
statements are already committed.

Helen