Announcement

Collapse
No announcement yet.

write protection for data record

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • write protection for data record

    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/...ing-reads.html for similar things in mysql.

    Comment

    Working...
    X