Problem with the limit of a text variable

AitorEG

Hi everyone,

I have a small problem with a text variable in NAV. This text variable, is writen in a file with the "WRITE" method, and must be everyhing in the same line. The issue, is that this line has 1047 positions, and the text data type only allows 1024 positions.
The problem is that the "WRITE" function, inserts automatically the line break, so I can't divide the data into 2 text variables, and write them separately.
How would you solve this issue? Is there any way to not insert the line break when writing? Or, can I usea any other data typo to generate the line?

Thank you very much

Slawek_Guzek

Put your text into BigText variable type, adding chunk by chunk using ADDTEXT, and then stream out the big variable into a file.

This method has an opposite problem - it does not write any new lines. If you need some then you need to add new lines explicitely by appending a short text consisting of 0x0d and 0x0a characters in places where you want your linebreak.

Slawek

Slawek_Guzek

On a second thought - you have posted your quesion in NAV Three Tier - NAV 2013+ does not have a limit on Text variable lenght, just leave the lenght on your text variable definition blank

Slawek

vaprog

Also, check out the OutStream data type. It does not add a line break on each write. Use an OutStream.WRITETEXT call without a parameter to actually write a line break. This way you likely don't even have to construct your line in a Text variable in the first place.

Juhl

In 2009 and 2013 you can use Dotnet System.String instead of Nav Text datatype

jaclyn

https://msdn.microsoft.com/en-us/library/dd338712.aspx
Big Text Data Type
Microsoft
The maximum length of a Big Text variable is 2,147,483,647 characters and this corresponds to 2 GB.
I hope it will help you in this scenario.

AitorEG

Thanks for the anserws, I will work on it!!