Re: Variable length fields

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