I had two problems but how did that decide how right this decision is?
Database Firebird 3
I was so
Code: Select all
UniConnection - AutoCommit=False
TransactionRead - ReadCommited
TransactionWrite - Snapshot
UniConnection - Transaction - TransactionRead
Uniquery-CachedUpdate = True
Uniquery-UpdateTransaction-TransactionWrite
Code: Select all
Uniquery.Post;
Uniquery. ApplyUpdates
Uniquery. CommitUpdates
try
TransactionWrite .startTransaction
TransactionWrite .Commit
except
TransactionWrite .Rollback
showmessage('Error')
end
When the second time I pressed the save button after rollback get error update data not found(0)
I find solution Uniquery options strictupdate=false
Now another problem after rollback
Can't perform operation on inactive transaction
I read in this forum i find solution but is it right way?
Code: Select all
UniConnection = AutoCommit=True
Uniquery.Post;
Uniquery. ApplyUpdates
Uniquery. CommitUpdates
try
TransactionWrite .startTransaction
TransactionWrite .CommitRetaining
except
TransactionWrite .RollbackRetaining
showmessage('Error')
end
I want control manually transaction