New field not saving to database.
derekj22
Member Posts: 16
I created a new field in Service Header (ID: 5900). This field has a type of Option. When I add the field to the Service Order Page (ID 5900) I can select a value and click ok and the value persists. However, when I add the Field from Service Header to the Service Item Worksheet Page (ID 5906), the selected value will not save to the database.
In the Service Order Page if I leave the prefix ServHeader."New Field" it will not save. Once i remove the ServHeader prefix it will then save.
My questions are the following:
Why will my selected values not save when the prefix ServHeader exists in front of "New Field" on the Service Order Page, but when I remove it, they save?
Also, what am I missing in regards to referencing the ServHeader."New Field" on the Service Item Worksheet and why it won't save?
Thank you!
In the Service Order Page if I leave the prefix ServHeader."New Field" it will not save. Once i remove the ServHeader prefix it will then save.
My questions are the following:
Why will my selected values not save when the prefix ServHeader exists in front of "New Field" on the Service Order Page, but when I remove it, they save?
Also, what am I missing in regards to referencing the ServHeader."New Field" on the Service Item Worksheet and why it won't save?
Thank you!
0
Best Answer
-
Hi,
a) ServHeader is a global helper variable and not the current record on the page ( use Rec. for that and Nav understands when you leave out Rec. and just use the field name ).
b) The current record on the page is not a Service Header and ServHeader is a global helper variable. If you want to set the field value in this page you have to program it.
You have posted in the wrong category
should be NAV three tier.
Good luck, let us know how it works out.\\The truth exists in seven versions.5
Answers
-
Hi,
a) ServHeader is a global helper variable and not the current record on the page ( use Rec. for that and Nav understands when you leave out Rec. and just use the field name ).
b) The current record on the page is not a Service Header and ServHeader is a global helper variable. If you want to set the field value in this page you have to program it.
You have posted in the wrong category should be NAV three tier.
Good luck, let us know how it works out.\\The truth exists in seven versions.5 -
Whenever you make any changes to your database, please make sure that your app/config/core.php file debug value is 2. Configure::write('debug', 2);
If it is 0 database changes will not be detected.-1
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