Microsoft Dynamics AX (Archived)

Assign a value to string(memo) from container

(0) Share

Report

Posted on by OrangeRocks

700

Dear community,

I would like to assign a container value to a field of type string (Memo):

myTable.StringMemoField = con2Str( myContainer );

myTable.doUpdate();

When I do this, the string (Memo) field gets cut at around 20th line. The container is a large one and has around 500 lines.
How can I assign the string (Memo) field correctly?

[EDIT]: con2Str has a limitation of a 1000 signs. How can I declare the return type of a function to string memo?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

It is unlikely that you are hitting the boundary limit of a Memo field due to the enormous size it can take in:

community.dynamics.com/.../216473

Did you try to debug the conversion? It is a method in the Global class, place a breakpoint in there and check if the full container length is correctly processed, and if the value of the string it stores content in does change indeed.

Maybe it is just a display issue once you bind it to a form string control.

Was this reply helpful? Yes No
OrangeRocks 700 on at

Like (0)

Report
con2Str cuts my value at the place of 1000 signs.

I would like to create my own function like con2Str, but declare the return type not

str 1000

but something like

str (Memo)

Is there a way?

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

In later AX versions the Memo is an SQL Server BLOB column, but if my memory does not fail me, in AX 4.0 they might have just used a large string that has 1000 characters length indeed (by default, if you do not change it).

If you increase that in the System data types form, that can have negative performance implications and could drop your fields in the DB on synchronization to recreate it with a different length, so be careful here.

The solution is to use a container field instead of string.

Was this reply helpful? Yes No
Suggested answer

OrangeRocks 700 on at

Like (1)

Report
A simple code did the trick, no use if con2Str whatsoever:

myTable.StringMemoField += conPeek( myContainer, counter ) + " "; myTable.doUpdate();

Was this reply helpful? Yes No

Community site session details

Assign a value to string(memo) from container

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Assign a value to string(memo) from container

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates