Hi How many fieles can we created in a table ? I have got an error message stating ‘Not more than 2000 bytes allowed in active fields’ when I tried to create a new field in Debitor table. Regards Joseph MAthew
there is a theoretical maximum of 1 million fields in a table, however, the max record side applies, and that is 2K until version version 2.5. From 2.5 and upwards the max. record size is 4K. Lars Strøm Valsted Head of Project and Analysis Columbus IT Partner A/S www.columbusitpartner.com
What about Navision Attain 3.0? Has this changed here? Best regards, Erik P. Ernst, webmaster Navision Online User Group
In 2.65 and 3.00 Beta it is still 4K so nothing seems to have changed. Paul Baxter
quote:
there is a theoretical maximum of 1 million fields in a table, however, the max record side applies, and that is 2K
Lars, I wonder how you want to squeeze 1 Mio fields in a 2K record. Average field-size 0.002 Bytes? So much about theoretical values issued by Navision. ------- With best regards from Switzerland Marcus Fabian
Practically you can add about 100-150 fields to a table. We support a site that we didnt implement and this customers tables are right on the 2k limit in 1.3 and also now in 2.01B (we will change the design in 2.6/3). I think its fair to say that if you are adding this many fields then you may need to reconsider the design you have chosen if you are modifying native tables (especially line tables that get fully posted). Its easy to link to another table and post these ones seperately. This reduces upgrade nightmares and increases speed! Craig Bradney Technical Manager Navision Solutions & Services, Deloitte Touche Tohmatsu Email:cbradney@deloitte.com.au Edited by - cbradney on 2001 Jun 20 01:12:40
With proper database design would you ever really need so many fields in a table? If you are storing so many attributes about an entity, perhaps you should rationalize the entity. In OO terms, consider refactoring. Jim Hollcraft NCSD, NCSP, MCSE, CNE, MCP, MST aka Skater http://drilldot.com Unauthorized Navision News
quote:
With proper database design would you ever really need so many fields in a table?
Yeah, happend once. Table 36 for a fruit/vegetable merchant. They really DO need a hell lot of additional information in the sales-header. The Item table is also a candidate for reaching the 2k limit soon. ------- With best regards from Switzerland Marcus Fabian