Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
How to lock table on record level?
mtlmonk
Member Posts: 48
Hi,
How can I tackle the following situation:
On periodic event, there is an automatic process that will read an xml file and make changes to a sales order / lines through web service.
On the other hand, we've got users making changes to the orders.
We've had issues where the automatic process would not update the record because between the moment the order is read and modified, a user has made a change to the order.
How can we lock the record once the automatic process reads a sales header/line until it's finished being modified?
LOCKTABLE after it's read? When does NAV release the "lock"?
How can I tackle the following situation:
On periodic event, there is an automatic process that will read an xml file and make changes to a sales order / lines through web service.
On the other hand, we've got users making changes to the orders.
We've had issues where the automatic process would not update the record because between the moment the order is read and modified, a user has made a change to the order.
How can we lock the record once the automatic process reads a sales header/line until it's finished being modified?
LOCKTABLE after it's read? When does NAV release the "lock"?
0
Answers
TheTable.LOCKTABLE;
It does not lock the table (it did in the classic DB...), but in only starts reading with EXCLUSIVE LOCK the records after the command. They will be released when your transaction is COMMITTED to the DB (or an error is raised).
But I wonder: how much time does it take between reading the line and updating it?
There shouldn't be that much difference. If there is, maybe you should also review the automatic process to make it shorter between reading and updating.
Keeping data locked too long is not a good idea for any ERP. Yes, it makes sure no one will change your data between reading and updating, but concurrence is at risk.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!