Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Changing transaction type from UpdateNoLocks to Update
Cindy_Pret
Member Posts: 8
Microsoft Dynamics NAV Classic
You cannot change the transaction type after you start the transaction.
A transaction starts when the program executes the first database operation, such as FIND, NEXT, INSERT, DELETE, MODIFY, SUM, and COUNT.
The error occurred because you were trying to change the transaction type from UpdateNoLocks to Update.
OK
0
Comments
I suppose your question is: What causes this error?
It means you are in a transaction with a certain transaction type. And you want to change the transaction type.
Probably in your code is some "CURRENTTRANSACTIONTYPE"-command to change it.
Or maybe you are in a transaction and run a report that has property "TransactionType" set to a different value.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
I got the error on a report that is utilized for processing. The transaction type of the report was set to update. I then changed the transaction type to UpdateNoLocks, and the issue were resolved.
Thank you once again.