Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
OnModify trigger on Job table (167) in NAV 2017
piktaz
Member Posts: 9
Hi,
I have this small problem with Job table in NAV 2017 and can't figure it out. The problem is with OnModify() trigger which gets executed every time any of the flowfields on this table get drilled down.
For example, in OnModify() trigger I add this:
Then open the table in windows client and drill down any flowfield, let's say "Comment" field:
When I close the "Comment List" and try to close the Job table I get this:
This can be replicated in Cronus 10-0 database. I've even removed all the code from the Job table and left just the standard fields with no code behind them whatsoever. Still error occurs. In fact, this is the only table that has this behavior, or at least what I've encountered in my environment. I can create a brand new page for this table with just one flowfield, if I drill it down - error occurs. The debugger is of no help, catches just the OnModify trigger with no execution trace in call stack. No extra movement in "Event subscriptions.." (number of calls) window too.
I imagine it's something very simple, perhaps an event/subscription outside the table or a subtle property somewhere. Any input would be highly appreciated.
Many thanks!
I have this small problem with Job table in NAV 2017 and can't figure it out. The problem is with OnModify() trigger which gets executed every time any of the flowfields on this table get drilled down.
For example, in OnModify() trigger I add this:
Then open the table in windows client and drill down any flowfield, let's say "Comment" field:
When I close the "Comment List" and try to close the Job table I get this:
This can be replicated in Cronus 10-0 database. I've even removed all the code from the Job table and left just the standard fields with no code behind them whatsoever. Still error occurs. In fact, this is the only table that has this behavior, or at least what I've encountered in my environment. I can create a brand new page for this table with just one flowfield, if I drill it down - error occurs. The debugger is of no help, catches just the OnModify trigger with no execution trace in call stack. No extra movement in "Event subscriptions.." (number of calls) window too.
I imagine it's something very simple, perhaps an event/subscription outside the table or a subtle property somewhere. Any input would be highly appreciated.
Many thanks!
0
Best Answer
-
Optionspiktaz
Member Posts: 9
I have found the culprit. It's a datatype "Media" (Field 140 "Image", Type: Media) that fires OnModify trigger every time a flowfield gets drilled. Even when media field is not exposed to the page.
Changing datatype to MediaSet solves the problem.
1
Answers
Changing datatype to MediaSet solves the problem.
I just tested this on 2 customer systems, i am implementing, where i use Media. (so this is kind of interesting for me). This is on Item table.
But I cant replicate this! Both running on CU4.