Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 663 Most Valuable Professional
André Arnaud de Cal... 540 Super User 2025 Season 2
Sohaib Cheema 348 User Group Leader
