Devart Forums

Hello

Here I have another locking question.

I am doing MyQuery.locktable on one table. Then from other application I try to edit a field from that table. I cannot do this. Which is correct. But the problem is that I do not get a lock timeout exception. Is this right?

And if I am editing a record in one application and issue LockTable in another I can get the lock on the table but I cannot post the record from the first application. Which let's say I can understand, but I still do not get lock timeout exception.

Is this right not to get the exception?

Try to perform immediate lock before editing a record. After the time interval specified in the innodb_lock_wait_timeout server variable expires, an exception will be raised. See the Lock demo of MyDAC for more information.

We will investigate possibility to improve work with locking in MyDAC.