Hello
I was investigating Lock methods with MyDAC and I've tried MyDAC Lock Demo for this. This is what I've found out.
1. Open tables
2. Select lock type of the first connection to Delayed
3. Put one record of the first connection in edit mode and change a field
4. Put the same record of the second connection in edit mode and change a field
5. Post second connection - here you will have to wait for one min then you will get an exception. Which is normal cause the record is locked by first connection
6. Press Cancel for second connection - the record should be released
7. Post the first connection. Here even the record was released at step 6 we still have to wait for one min and we get the lock_timeout_exceeded exception!!!!
Now whatever I do I cannot edit this record from the first connection, even if I disconnect and connect again. I have to restart the application for this.
As I suppose this is wrong. Tell me what you think of this.
And when will be the next release of MyDAC be with improved lock functionality?
Thanks