Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

hi all lock obj

Former Member

‎2007 Sep 04 8:24 AM

0 Likes
306

hi all

i would like to know the diff between lock modes.

1. exclusive. 2. sharing 3. excusive and cumulative.

Pl write in layman's language. no big therory.

write just 1 or 2 lines.

no coding please.

thanx

rocky

hi all

i would like to know the diff between lock modes.

1. exclusive. 2. sharing 3. excusive and cumulative.

Pl write in layman's language. no big therory.

write just 1 or 2 lines.

no coding please.

thanx

rocky

Reply
1 REPLY 1
Read only

varma_narayana
Active Contributor

‎2007 Sep 04 8:32 AM

0 Likes
282

Hi..

Shared lock : is used while trying to Read the record using SELECT query. Multiple users are allowed to Create Shared lock on the same record at a time.

Exclusive Cummulative ('E') : Only one user is Allowed to Update the Record . All further lock requests on this record will be granted as shared lock.

Exclusive Cummulative ('X') : Only one user is Allowed to Update the Record . All further lock requests on this record will be REJECTED.

<b>Reward if Helpful</b>