problem in locking the database table

[Former Member]

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 Member]

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

[Former Member]

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]

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]

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

[SuhaSaha]

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