Late write of NAS and SQL
Cem_Karaer
Member Posts: 281
Hello,
I have a web application that uses NAS to create sales orders. On another place of the web application I show total sales amounts in the current month. Totals are calculated with ADO.NET SQL queries. The SQL query doesn't catch new sales line created by the NAS. Do you ever meet such a problem?
I have a web application that uses NAS to create sales orders. On another place of the web application I show total sales amounts in the current month. Totals are calculated with ADO.NET SQL queries. The SQL query doesn't catch new sales line created by the NAS. Do you ever meet such a problem?
Cem Karaer @ Pargesoft
Dynamics NAV Developer since 2005
Dynamics NAV Developer since 2005
0
Answers
-
Are you using COMMIT statement after creating saleslines from NAS ?0
-
No, should I?Cem Karaer @ Pargesoft
Dynamics NAV Developer since 20050 -
Re-getting the inserted record in C/AL solved the problem.Cem Karaer @ Pargesoft
Dynamics NAV Developer since 20050
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 328 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