Field Size more than 250 characters ?

NAVKING

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 ?

HalMdy

Since Version 4 , you can use BigText variable. Maximum size is then 2Gb ! See version 4 doc for details ...

jhoek

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!

Waldo

... 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...

Captain_DX4

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).