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
Need To Update a Field On the Onafterget record tri of form
Prem
Member Posts: 34
Hi All
I would like to disable a record when it is viewed or active in another users screen.
How can i acheive this...?
Cheers
Prem
I would like to disable a record when it is viewed or active in another users screen.
How can i acheive this...?
Cheers
Prem
0
Comments
You don't really need to worry about this as Navision Proprietary database is built around optimistic concurrency. This means that the user who changes the record first is guarenteed that their change will be the one that takes effect. Any other users who were viewing the same record at the same time and try to change it will receive an error stating that the record was changed after it was retrieved from the database.
SQL also has it's own build-in mechanisms for dealing with this situation but my knowledge of SQL is very sketchy.
The Application Designer's guide tells you everything you need to know about table locking for both versions of Navision.
Hope this sort of answers your question