OnModify trigger on Job table (167) in NAV 2017

piktaz
Member Posts: 10
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
-
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
-
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 -
That's definitely a bug in the client - you should report to Microsoft0
-
Reported.0
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