topic Re: Row Level Locking while inserting a record. in Application Development and Automation Discussions

Row Level Locking while inserting a record.

Former Member — Fri, 04 Apr 2008 12:35:54 GMT

It is a good practice to lock the whole table or do the row level locking while performing any DELETE / UPDATE / MODIFY actions on a database table. Is it necessary to do the same thing while inserting a record via INSERT statement?

One point may arise if two users are inserting same records at a same time....

Well i am little bit confused here bcos if a record doen't exist in a table what is the point of locking it.

Please help me.

Re: Row Level Locking while inserting a record.

Former Member — Fri, 04 Apr 2008 12:49:14 GMT

create a lock object using SE11 for that perticular table and include field names in Lock parameters. Then it will generate two FMs one for locking and another for unlocking.

Call the lock FM before updating the table and pass that row key value(For fields which taken in lock parameters for creating lock objects) to the exporting parameters.

Then do the updation.

Reward if useful...................

Re: Row Level Locking while inserting a record.

Former Member — Fri, 04 Apr 2008 13:46:12 GMT

Well Poorma, U are quite right about how to make a lock objects and how to use them, but my question is different here. I want to know that whether one should use row level locking while insertion or not.