MS Navision - Table Locking
Posted by: kaizenlog in Navision, tags: MS Navision - Table LockingMS Navision - Table Locking
In the majority of cases Navision takes care of locking so you do not need to do anything.
In the rest of the cases you have to lock the table.
To lock the table, use the LOCKTABLE function.
This locks the table until the write transaction is committed/aborted.
Other users can read from the table but cannot write to it.
COMMIT unlocks the table.
RECORDLEVELLOCKING is used to detect whether record level locking is being used.
This is only available if SQL Server DB is used.
Popularity: 1% [?]
Welcome back to Kaizenlog.com, you may want to subscribe to my RSS feed , Twitter You can contact us by using the contact form or submitting a comment. You can also share this post with your friends by clicking on the 'ShareThis' button above. Thanks for visiting!
Print This Post
Entries (RSS)