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
dyc>  

read about IB/FB transaction parameters.

-- 
Dmitry Kuzmenko, www.ib-aid.com

Reply via email to