Difference between revisions of "APPEND MEMO"
From Lianjapedia
(→Products) |
Yvonne.milne (Talk | contribs) |
||
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Add a text file to a memo field | Add a text file to a memo field | ||
− | |||
==Syntax== | ==Syntax== | ||
APPEND MEMO <memo fieldname> FROM <filename> [OVERWRITE] | APPEND MEMO <memo fieldname> FROM <filename> [OVERWRITE] | ||
− | |||
==See Also== | ==See Also== | ||
− | [[COPY MEMO]], [[MEMOREAD()]], [[MEMOWRITE()]] | + | [[COPY MEMO]], [[MEMOREAD()]], [[MEMOWRITE()]] |
− | + | ||
==Description== | ==Description== | ||
The APPEND MEMO command adds the specified text file to the memo field of the current record. The <memo fieldname> of the current record in the active table is appended with the text in the file specified by <filename>. If no file extension is specified with <filename>, a '.txt' extension is assumed. | The APPEND MEMO command adds the specified text file to the memo field of the current record. The <memo fieldname> of the current record in the active table is appended with the text in the file specified by <filename>. If no file extension is specified with <filename>, a '.txt' extension is assumed. | ||
− | |||
====OVERWRITE==== | ====OVERWRITE==== | ||
The optional OVERWRITE keyword causes the APPEND MEMO command to write over pre-existing text in the memo. Without the OVERWRITE keyword text will be appended to the memo field. | The optional OVERWRITE keyword causes the APPEND MEMO command to write over pre-existing text in the memo. Without the OVERWRITE keyword text will be appended to the memo field. | ||
− | |||
==Example== | ==Example== | ||
Line 24: | Line 19: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
+ | [[Category:NoSQL Commands]] | ||
[[Category:Memos]] | [[Category:Memos]] | ||
− |
Latest revision as of 05:42, 19 August 2022
Purpose
Add a text file to a memo field
Syntax
APPEND MEMO <memo fieldname> FROM <filename> [OVERWRITE]
See Also
COPY MEMO, MEMOREAD(), MEMOWRITE()
Description
The APPEND MEMO command adds the specified text file to the memo field of the current record. The <memo fieldname> of the current record in the active table is appended with the text in the file specified by <filename>. If no file extension is specified with <filename>, a '.txt' extension is assumed.
OVERWRITE
The optional OVERWRITE keyword causes the APPEND MEMO command to write over pre-existing text in the memo. Without the OVERWRITE keyword text will be appended to the memo field.
Example
append memo minutes from meeting