topic Re: Lock object vith forgien key in Application Development and Automation Discussions

Lock object vith forgien key

Former Member — Sun, 19 Jul 2009 07:41:59 GMT

HI All,

I have 4 table that are related via forgin key ,i want to create lock object and my question

is if i need to create lock object for each table or just one lock object.

Best Regards

Joy

Former Member — Sun, 19 Jul 2009 07:53:16 GMT

For Lock objects with foreign key , lock object for the primary table alone is enough .

Check below links

Former Member — Sun, 19 Jul 2009 08:19:18 GMT

Hello KArtik ,

i read the help and one thing that i don't understand is if i have different tables that

the forging key is for instance employee .

when i create lock object enqoue and denque the FM that generate is different so how i can

use just one lock object ?

Regards

Joy

Former Member — Sun, 19 Jul 2009 08:47:41 GMT

I think u are using custom tables..its better to create lock for all tables and update tables and unlock all..

cheers

Former Member — Sun, 19 Jul 2009 09:22:34 GMT

HI ,

What does it mean ,if the tables are relate via foreign key and i lock one table to update,

does it mean that all the related tables are locked or not ....?

Best Regards

Joy

Edited by: Joy Stpr on Jul 19, 2009 9:02 PM

Former Member — Sun, 19 Jul 2009 23:08:04 GMT

I dont think related tables will be locked as you are just updating not inserting new record...

Problem might come when u want to insert new record in one of secondary table..

cheers

Former Member — Mon, 20 Jul 2009 04:54:51 GMT

its simple dear,

the number of table you are updating in one go will form the tables in locking objects

for example in save command you are updating 3 table then you will lock three table

and just readting from master table then you will create a seperate lock for your master table ..

i.e you will put a read lock on your master table and write lock on your child table..

just put read lock on master first if successfull. the place the write lock on the child.

Regards