updating a memo field progromaticly

[1421]

Hi All

I am trying to update a memo field within a program. what are the available commands. I have never worked with memo fields

 

[JRB-Bldr]

From the programmer's perspective, a memo field works like any other character field. A Memo field works like a LONG character field.

Example:
REPLACE MyTable.ThisMemo WITH <whatever character(s)>

When extracting the Memo field's value, again, it works just like another character field.

Example:
mcMyTableMemo = ALLTRIM(MyTable.ThisMemo)

There are a few other concerns about using Memo fields such as the possibility of Memo table corruption, etc., especially if the Memo table grows too big, but most of the time, they work well when you need to hold larger quantites and/or multi-line (with embedded CRLF's) character strings.

Displaying the contents of Memo fields on a Screen/Form can sometimes present a challenge, but this too can be done.

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com

 

[DSummZZZ]

One difference to keep in mind is when using GATHER MEMVAR or SCATTER MEMVAR, you must include the keyword MEMO in order for the memo field to be included:

SCATTER MEMVAR MEMO
-or-
GATHER MEMVAR MEMO

The MEMO keyword will have no effect if there are no memo fields in the table, but it memo fields won't be included if there are memo fields and you don't include it.

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm