Maximum No. of possible fields in Navision

vijay4398vijay4398 Member Posts: 35
is there any restriction on the number of fields that one can create in a Navison table?

Thanks in advance,

Vijay

Comments

  • vijay_gvijay_g Member Posts: 884
    it's being measure in bytes that is 4028 something.
  • chengalasettyvsraochengalasettyvsrao Member Posts: 711
    vijay_g wrote:
    it's being measure in bytes that is 4028 something.

    yes , it is not based on the fields
  • David_SingletonDavid_Singleton Member Posts: 5,479
    This is not a good question to be asking. Especially if you are working with SQL.

    You need tables to have fewer fields, not more. The more fields there are the slower your system will be. Work on optimizing your database design so that you never come to a point where you need to know how many you can add.

    If you reach the error message limit, then you really have too many fields and need to rethink your system design.
    David Singleton
Sign In or Register to comment.