Reocrd has NO-LOCK status

[whaha]

Dear All,

I've encountered a problem when direct updating the database, it display record has NO-LOCK status, update to field not allowed unable to update xxxx field.

Thanks in advance.

 

[parul]

Probably the record you are trying to update is in NO-LOCK mode.
A record has to be in EXCLUSIVE-LOCK before you can update it.

So drop the no-lock from the query you are using to find the record and use EXCLUSIVE-LOCK instead.

You should go through the programing handbook, concept of lock is explained there in detail.