Page 1 of 1

Locking problem

Posted: Sun 14 Mar 2010 20:34
by hills1
Hello,

I'm having a problem with record locking.

I've seen the lock demo, and this works very good. I am trying to use this code in my app but this doesn't work properly.
If one user is locking a record, another user is not able to lock a different record, then exception is like trying to lock the same record. (lock request time out period exceeded).

Can anyone give me a hint what i'm doing wrong? Any help would be appreciated.

Thanks in advance,

Wim.

Posted: Tue 16 Mar 2010 15:27
by hills1
Hello,

Could it be that row locking is not possible if a table doesn't have a primary key field?

Wim.

Posted: Wed 17 Mar 2010 09:10
by Challenger
Yes. Your table should have Primary Key.