I m using NAV 4.0 SP3 IN version SQL DB.Can we increase the length of table which is 4000bytes by Default? I have 1 table(say,81) of 4000 bytes.My DB is in Hot Fix 5.I want to merge Hot Fix 6 in this DB.In Hot Fix 6 there are some new fields in Table 81 and my table(81) have already size of 4000 bytes.Then, How can I import those new fields which are available in Hot Fix 6 in table 81.
Vikram Dabas
Navision Technical Consultant
0
Comments
First of all Fields are mandatory in table 81,I cant remove any field, please give me some other solution.
Navision Technical Consultant
RIS Plus, LLC
Ok, maybe all fields are mandatory. Is there a way to reduce their size? Do you have any text fields like descriptions that could be reduced (Custom ones)? If not, then there is no other way, as suggested by David.
Define "Mandatory" in this case?
You have two choices. Remove fields and redesign your solution. Or add a second table and redesign your solution. If those fields are all mandatory then you only have option two.
Instead of creating new fields, you might look into using dimensions instead.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
Scary isn't it.
It would be scary if the fields were truly necessary,
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book