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
- 262 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
Active fields limit exceeded
Dneal
Member Posts: 103
I added extra fields to the Sales Header table. The last field that I added gave me an error message that the active fields in a record may not take up more than 4000 bytes.
Does anyone know if this can be adjusted, or is it an absolute.
Thanks,
Dneal
New Navision Developer
Does anyone know if this can be adjusted, or is it an absolute.
Thanks,
Dneal
New Navision Developer
0
Comments
The limit was extended from 2000 to 4000 somewhere around version 2.5/2.6, so it is not absolutely impossible that it might change sometime in the future, but I've not heard any rumor in that direction.
If that should happen, however, going past 8000 bytes would be very hard, because SQL Server tables cannot have row sizes that exceed 8000 bytes.
If you realy need to store extra data then you can make a new table with the same key, move the largest custom fields to it and show them in the form like the shortcut dimensions. (save/update etc.)
This is quite a job but is better than trying to decrease standard Navision fields in size.
DNeal