Size does matter.

Bgestel
Bgestel Member Posts: 136
edited 2007-06-14 in NAV/Navision Classic Client
Hi,

Question 1:
I can i quickly know the size of my record definition.
Is this the blob size or one of the size's in database->information->tables

Question 2:
What is the maxium size a record definition can be?

I ask this because i Fear running in to the techical maximum size for the purchase line. And would like to anticipate on this.

Question 3:
Who has a smart idea , say i want to add another field to the table when the maximum size is reached. The only constraint is that they need to be presented in the same tablebox on the form.

Thx in advance
**********************
** SI ** Bert Van Gestel **
**********************

Comments

  • fufikk
    fufikk Member Posts: 104
    I guess I would create second table with the same PK, add required fields, and on the form (with the initial-out-of-fields-table) make use of OnAfterGetRecord trigger or something - fetch the record from the secod table and show stuff on the form
  • ara3n
    ara3n Member Posts: 9,258
    I agree with fufikk.
    Also your title looks like a lot of spam that I get on my hotmail account. :mrgreen:
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Bgestel
    Bgestel Member Posts: 136
    thx for the answers to question 3 , now what about 1 and 2 :?:
    **********************
    ** SI ** Bert Van Gestel **
    **********************
  • kriki
    kriki Member, Moderator Posts: 9,121
    ara3n wrote:
    Also your title looks like a lot of spam that I get on my hotmail account. :mrgreen:
    True, when I saw the title I was already ready to moderate the post until I read it and saw it wasn't spam. :mrgreen:
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Bgestel
    Bgestel Member Posts: 136
    I used that title to lure in , the knowledge full moderators. :whistle:
    **********************
    ** SI ** Bert Van Gestel **
    **********************
  • Arhontis
    Arhontis Member Posts: 667
    Bgestel wrote:
    Question 1:
    I can i quickly know the size of my record definition.
    Is this the blob size or one of the size's in database->information->tables

    The record size in on database->info....
    The blob size on object designer is the size of the object.

    I guess the max size depends on the SQL server, don't know about the native version of nav...
    Regards,
    Arhontis

    https://forum.mibuso.com/search
  • Arhontis
    Arhontis Member Posts: 667
    EDIT:reposted the same... I must be drunk...:mrgreen:
    Regards,
    Arhontis

    https://forum.mibuso.com/search
  • DenSter
    DenSter Member Posts: 8,307
    You can disable fields that are not used, and that takes away from the max record size.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • DenSter
    DenSter Member Posts: 8,307
    Oh and ehm.... you're right, it does :whistle:
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • David_Singleton
    David_Singleton Member Posts: 5,479
    Bgestel wrote:
    Hi,

    Question 2:
    What is the maxium size a record definition can be?

    The maximum size of the record definition is 4000 bytes. This is a limitation since ver 2.01, and for compatibility between native and SQL, the same limit applies to SQL.

    This is the total of the maximum size of fields if fully populated. Calculating it is a bit complex, but the formula is in the manuals.
    David Singleton

Categories