Devart Forums

I am using Oracle XE with ODAC ver 7.20.0.6 and Delphi XE
In a multiuser situation sometimes(quite often, but not always) a user is not notified that another is editing that record and allows that user to proceed with the obvious consequences. The component used is TsmartQuery configured as follows: LockMode:lmLockImmediate, CheckMode:cmException, AutoCommit:True. FetchRows=1. As I have been unable to replicate the problem every time, it has proved impossible to solve. Any suggestions would be welcome.

Hello,

I cannot reproduce the problem.
If I try to edit a record (that is being edited), the ORA-00054 error always occurs.
You can try to block records yourself using the For Update nowait construction
If you can, create a small test project demonstrating this problem and send it to alexp*devart*com.