OnModify Trigger

21ahmed
Member Posts: 24
Hi,
I want to block the modification of sales line (All fields), so i added an ERROR message at the OnModify Trigger of the table 37.
The problem that the message appear when i try to change all fields expected the two fields "Type" and "No.".
I want to know why Navision doesn't block for these two fields although they are not included in the primary key of the table. And if you met this problem before, how can i solve this.
Thank you all
I want to block the modification of sales line (All fields), so i added an ERROR message at the OnModify Trigger of the table 37.
The problem that the message appear when i try to change all fields expected the two fields "Type" and "No.".
I want to know why Navision doesn't block for these two fields although they are not included in the primary key of the table. And if you met this problem before, how can i solve this.
Thank you all
0
Comments
-
http://msdn.microsoft.com/en-us/library/dd355319.aspxWe recommend that you do not include code that can stop the user from recording a change in the OnModify trigger on a table. For example, do not include code for displaying error messages. If a user has previously changed the contents of some fields in a record, then these changes must always be accepted by the system.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