topic Re: problem in locking the database table in Application Development and Automation Discussions

problem in locking the database table

Former Member — Wed, 07 Oct 2009 09:13:26 GMT

hi, Experts

i have problem with lock to the table.

i have use following code.

CALL FUNCTION 'ENQUEUE_EZCUSTOMER'

EXPORTING

MODE_ZPVCUST = 'X'

MANDT = SY-MANDT

CUSTNO = zpvcust-custno

and if i m writing any update query to the zpvcust table then that query executes successfully.

plz help me

former_member209217 — Wed, 07 Oct 2009 09:18:11 GMT

Hi,

Only you will be able to update the table which is locked by you.

To check whether its locked or not goto SM12 and press enter . You should be able to see the name of the table if its locked

Regards,

Lakshman.

SuhaSaha — Wed, 07 Oct 2009 09:21:36 GMT

Hello,

The table entry will be locked only if some other user is trying to modify the same entry, else it will not.

So whats bothering you my friend?

BR,

Suhas

Former Member — Wed, 07 Oct 2009 09:31:33 GMT

but if i m writing update query for that table then also table is updated.

SuhaSaha — Wed, 07 Oct 2009 09:34:45 GMT

Yes, it will be updated.

If you are assuming that creating a "table lock" will ensure that user cannot update the entry then you are mistaken.

What exactly is the business req. you are trying to achieve?

BR,

Suhas