Announcements
No record found.
Hi Folks,
I want to process a specific record but need to lock this record so it will not be processed by other users/ any running pre defined batch job.
Could anyone please help me out on this.
Thanks in advance!!
Hi, You can check how system is Blocking the journals and try to replicate it.
Hi,
You can use Pessimistic lock but I think it will affect the performance.
https://learn.microsoft.com/en-us/dynamicsax-2012/developer/optimistic-concurrency-control
https://dev.goshoom.net/2011/10/pessimistic-locking/
Refer to the below blog.
As soon as you select a record using "forUpdate" inside a transaction scope (ttsbegin), that record cannot be changed by someone else until the transaction is comitted by the process who started the transaction by calling ttscommit. This is a simplified description of how this works but that's basically the idea.
If you are working "outside" transaction scopes with multiple users editing data at the same time and just want a "single user mode" type functionality for records. You can add some custom fields to the table that indicate it's locked and by who. Logic can be added to allow only editing accordingly.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 689
André Arnaud de Cal... 478 Super User 2026 Season 1
Syed Haris Shah 258 Super User 2026 Season 1
