Subject Re[2]: [firebird-support] Deadlock
Author Dmitry Kuzmenko
Hello, dixonepperson!

Monday, March 17, 2014, 6:45:55 PM, you wrote:

dyc> That raises three questions:
dyc> 1) Should I put a WAIT in the procedure with a LOCK TIMEOUT?

depends of how you want to handle update/delete conflicts.

dyc> 2) Would it be better to a START TRANSACTION / COMMIT inside the
dyc> procedure as opposed to putting the transaction control in the FbClient?

you can't do it, at all.

dyc> 3) If I put it in the FbClient, what are the options I should
dyc> choose? Would it be better to put it on the FbCommand or the FbConnection

read about IB/FB transaction parameters.

Dmitry Kuzmenko,