I am having no luck in avoiding Transaction Exceptions.

Initially I used the standard parameters for a transaction of

"nowait","read_committed","rec_version"

Then I got a lot of lock conflict on NO WAIT transaction exceptions.

SO I went to a lot of effort to change parameters of Transactions to:

"wait","read_committed","rec_version"

No I get a lot of 

"deadlock update conflicts with concurrent update concurrent transaction"

errors.

So now I am stumped. All I want firebird to do is to wait for the previous transaction to finalise before it attempts to update a record. However I cannot seem to tell it to do that.

What to do?

Kind Regards,

Robert.