How to handle in Nav/SQL ?
navuser1
Member Posts: 1,334
Hi All,
Our Client has a New Table and this table gets data from various sources like through Navision, through SQL etc and it display the data...
This table has a field Named Entry No. and it should be incremented when it collecting the data.
But when it gets data from Navision, the Table INSERT trigger fire (Entry No. incremented) but the Table INSERT triggers not fire (Entry No. Incremented) when it gets data from the other source.
Whatever the source I want that the Table Field (Entry No) should be incremented at time of collecting the data
:roll:
Our Client has a New Table and this table gets data from various sources like through Navision, through SQL etc and it display the data...
This table has a field Named Entry No. and it should be incremented when it collecting the data.
But when it gets data from Navision, the Table INSERT trigger fire (Entry No. incremented) but the Table INSERT triggers not fire (Entry No. Incremented) when it gets data from the other source.
Whatever the source I want that the Table Field (Entry No) should be incremented at time of collecting the data
:roll:
Now or Never
0
Comments
-
It depends on how the data are stored there. If you are filling the data from outside, the NAV Application code is not called. You cannot run NAV code outside NAV client or NAV Application server. You need to have NAV be the active one to fill the data and run the code... 8)0
-
Thanks Kine ..Now or Never0
Categories
- All Categories
- 75 General
- 75 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
