Options

Field Size more than 250 characters ?

NAVKINGNAVKING Member Posts: 9
Navision has a limit on using 250 characters within a text field, Is there a way round this so that we could use more characters ?

Comments

  • Options
    HalMdyHalMdy Member Posts: 429
    Since Version 4 , you can use BigText variable. Maximum size is then 2Gb ! See version 4 doc for details ...
  • Options
    jhoekjhoek Member Posts: 216
    You could create several text fields, each 250 characters wide. Then you could create functions to get and set the text, and use a variable to display the text on forms. Users won't be able to filter on that column, though.

    Another approach, which is even more complex but allows you to store gigabytes of text, is a BLOB field.

    Otherwise, I think the 250 character limit on fields really is part of the client and cannot easily be circumvented.

    HalMdy, that sounds interesting. I think I'll take a look soon! :)
    Kind regards,

    Jan Hoek
    Product Developer
    Mprise Products B.V.
  • Options
    WaldoWaldo Member Posts: 3,412
    ... Or you can use WaldoNavPad from the download section ... \:D/

    About the BigText ...
    I understood this could only be used for streaming (XMLPorts ...) ... . You can't display the text in a message, for instance...

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    Captain_DX4Captain_DX4 Member Posts: 230
    Waldo wrote:
    ... Or you can use WaldoNavPad from the download section ... \:D/

    About the BigText ...
    I understood this could only be used for streaming (XMLPorts ...) ... . You can't display the text in a message, for instance...

    That was my understanding too. Textboxes on forms can show up to 1000 characters (I'm doing it since v3.01), but still do that inline editing when trying to edit the field (how anoying! *lol*). And reports cannot display more that 250 characters in a textbox in the sections else it'll crash. Those are the limitations as I know them, but I've not really tried pushing them further in the v4.0 database yet (even though they are supposed to remain the same as v3.70).
    Kristopher Webb
    Microsoft Dynamics NAV Developer
Sign In or Register to comment.