Memo Fields

Memo Fields

I have a memo field in a table, which has been scattered to memvar. I need to append a standard statement to the field once the user has completed entering data.

I am trying to achieve the following effect:


Can you show me a way?

What you have done so far is fine, but to update the memo field, you have to perform a GATHER MEMVAR MEMO. This takes the contents of the memory variables and moves them into the fields.Here is a code sample that creates a cursor with a memo field, scatters it into memory variables, updates the memory variable that represents the memo field, gathers the memory variables back into the cursor, and then shows you the contents of the memo field:

stdstatement = "this is my standard statement"CREATE CURSOR Rick (mDNote M)APPEND BLANKREPLACE mDNote WITH "Here is some text."SCATTER MEMVAR MEMOm.mdnote=m.mdnote+stdstatementGATHER MEMVAR MEMOMODIFY MEMO mDNote

If you were not using SCATTER, you could do the following:

REPLACE mDNote WITH mDNote+stdstatement

See also  How IoT Tech Will Transform Logistics

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist