write protection for data record

Applications Forms
#1

Hi,

I am developing a project management app for the company. My question: if two colleagues open/edit the same data record at the same time in a form application, is it possible to lock the record (read only) for whom opened the data later - something like the write protection in microsoft word. Any ideas? Thanks!

LG

#2

Technically yes, you should be able to use a SELECT FOR UPDATE …
Then if someone else wants to save the record he gets a record… I havent tried it in scriptcase tho. I know this works flawless in oracle…
Check out http://dev.mysql.com/doc/refman/5.0/en/innodb-locking-reads.html for similar things in mysql.