topic Re: Locking multiple records in a database table at a time in Application Development and Automation Discussions

Locking multiple records in a database table at a time

Former Member — Wed, 18 Feb 2009 13:35:47 GMT

Hi Experts,

I have a requirement to lock multiple records in the database table for writing. I have created lock object in SE11. But with this we have only 2 possibilities either lock entire table or lock a single record at a time.

My requirement is, i have table with key field PROJECTID. I want more than one project to be locked, but not the complete table. I dont have any other field in the table to compare.

Thanks in advance..

Regards,

Asrar

Re: Locking multiple records in a database table at a time

former_member156446 — Wed, 18 Feb 2009 13:42:49 GMT

Hi welcome to SCN...

in su21 you can add some more data elements in the same Authorization object..

J@Y

Re: Locking multiple records in a database table at a time

Former Member — Wed, 18 Feb 2009 13:45:40 GMT

My objective is not with authorization objects. I cant fix values for locking.

Re: Locking multiple records in a database table at a time

former_member156446 — Wed, 18 Feb 2009 13:59:18 GMT

you might have SAP_ALL access.. so you cannot test if its locking or not.....

AUTHORITY-CHECK OBJECT Hit F1 on this and find more info..

Re: Locking multiple records in a database table at a time

Former Member — Wed, 18 Feb 2009 20:29:25 GMT

Hi,

Try with FOR UPDATE in the SELECT sentence.

SELECT FOR UPDATE *

INTO Internal_Table

FROM Table

WHERE Conditions.

This sentence blocks the records that satisfy of the WHERE conditions.

Regards,

José

Re: Locking multiple records in a database table at a time

Former Member — Fri, 13 Mar 2009 07:13:16 GMT

I have used to lock the compolete table, and implemented the required logic in the program so that users did not get locking errors.

Re: Locking multiple records in a database table at a time

Former Member — Tue, 08 Sep 2009 19:39:41 GMT

Hi ,

Try with FOR UPDATE in the SELECT sentence.

SELECT FOR UPDATE *

INTO Internal_Table

FROM Table

WHERE Conditions.

UPDATE "Table_name" FROM TABLE Internal_Table.

COMMIT WORK.

This sentence blocks only the records that satisfy of the WHERE conditions (not the entire table) and unlocks after commit work.

Hope this information is help to you.

Regards,

José