Temporary tables and concurrency

samantha73
Member Posts: 118
Hi Guys
I have created a report based on a temporary table (combine sales orders and archived SO) and each time you run it , DELETEALL command is issued to delete existing records before loading new ones. Am I correct to assume that if two users are running the same report at the same time, there are two instances of the report and DELETEALL from one user does not affect the other user.
I have created a report based on a temporary table (combine sales orders and archived SO) and each time you run it , DELETEALL command is issued to delete existing records before loading new ones. Am I correct to assume that if two users are running the same report at the same time, there are two instances of the report and DELETEALL from one user does not affect the other user.
0
Best Answers
-
That is correct.There are no bugs - only undocumented features.0
-
Yes Absolutely.Thanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/0
Answers
-
That is correct.There are no bugs - only undocumented features.0
-
Yes Absolutely.Thanks
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/0 -
Yes, temporary tables run on client side of nav.1
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions