× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



The number one thing to remember about varying fields is to trim the date as it is loaded.

Old style string build:

fixedString = %Trimr(fixedString) + newContent;

New Style with varying:

varyString += %TrimR( newContent);

When you do it this way the length of the string is automatically adjusted. It is rarely necessary to manually set the length of a varying field via %Len.

If you are going to set the length manually you might as well use a fixed length field.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 9, 2018, at 1:35 AM, Don Brown <DBrown@xxxxxxxxxx> wrote:

Thanks Alan but I am referring to the *data portion of the field.

Before I added the line;

%len(rJsonString) = 100000 ;

When I tried to put data into the filed I received an error that the
string exceeded the field size because the length was set to 1

The field in the database is as you have said 30000 + 2

The variable in the program is 100000 + 4

So before I modify the data portion of the field (rJsonString) I manually
set the length to it's maximum of 100000.

After I have built the string I set the length based on what is now in the
field.


I hope this clarifies ?


Don Brown

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.