Skip to Content
author's profile photo Former Member
Former Member

how to unlock the data from other user while editing

Hi friends,

I have created 4 maintenance views for a table. While editing data by using one view, I must be able to edit other data of the same table using other different view. But it is showing "The data is locked by user pagidala and can be displayed only. do u want to display locked data?". I must not get this error, it must permit me to edit the data. How it will be possible?

Thanks,

Ramesh.

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    Posted on Oct 27, 2008 at 09:42 AM

    Maintenance views lock the whole table. If you want record locking, then you'll have to write your own screens and logic to handle the table maintenance.

    matt

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 27, 2008 at 06:31 AM

    Hi,

    I think Its not possible because If there is such type of option there will not be data security.

    i.e. while your maintaing the data in table others can change it simultaneously and it can lead to errors

    If you wish Go to SM12 and remove the lock manually

    Regards

    Prasanth

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 27, 2008 at 06:51 AM

    Hi Pagidala,

    Have you tried my idea of creation of transaction code for each view?

    Cheers!!

    VEnk@

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      yes, For each view i have created a transaction.

      while accessing the transaction only i am getting that error.

      Edited by: pagidala Ramesh on Oct 27, 2008 12:24 PM