Locking HowTo question ?

[AndrewCash]

I am using "lmLockImmediate" for locking my Dataset. This prevents two users editing the same record at the same time and works in principle.

To lock the record I just perform a DM->Table->Edit() call. After a few minutes though the lock is released by Oracle and other people can start editing the record even though the first person is still editing the record. Editing can sometimes take upto 20 minutes on some records.

Is there a call or a way that I can refresh the lock ? I would prefer to refresh the lock rather than increasing the timeout.

Any ideas would be appreciated. Other that that the components are working pefrectly.

Andrew Cash
Switzerland.

 

[Marco Kalter]

I'm not sure if locks actually time out as long as your session is alive. You should however be aware that your locks will be gone if you commit or rollback the session that the dataset is connected to. Maybe this is what happened?

------------------
Marco Kalter
Allround Automations

 

[AndrewCash]

Thanks for the information. I tracked this down to a Session->Commit() call that was hidden in my code.

Thanks again.