COPY MEMO Command

Copies the contents of the specified memo field in the current record to a text file.

COPY MEMO MemoFieldName TO FileName   [ADDITIVE]   [AS nCodePage]

Parameters

  • MemoFieldName
    Specifies the name of the memo field copied to the text file.

  • TO FileName
    Specifies the name of a new or existing text file to which the memo field is copied. If you do not provide an extension in FileName, a .txt extension is assigned. You can also include a path with the file name.

  • ADDITIVE
    Appends the contents of the memo field to the end of the specified text file. If you omit ADDITIVE, the memo field contents replace the contents of the text file.

  • AS nCodePage
    Specifies the code page for the text file COPY MEMO creates. Visual FoxPro copies the contents of the specified memo field, and, as it copies the data, automatically converts the data to the code page you specify for the text file.

    If you specify a value for nCodePage that is not supported, Visual FoxPro generates an error message. You can use GETCP( ) for nCodePage to display the Code Page dialog box, allowing you to specify a code page for the file Visual FoxPro creates.

    If AS nCodePage is omitted or is 0, no code page conversion occurs.

Example

In the following example, the contents of the memo field named notes are copied to a file called Test.txt. The memo field is then copied again and appended to the end of the text file.

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE employee && Opens Employee table
COPY MEMO notes TO test.txt
WAIT WINDOW 'Memo contents now in test.txt' NOWAIT
MODIFY FILE test.txt
COPY MEMO notes TO test.txt ADDITIVE
WAIT WINDOW 'Memo contents added again to test.txt' NOWAIT
MODIFY FILE test.txt
DELETE FILE test.txt

See Also

APPEND MEMO | COPY FILE | COPY TO | MODIFY MEMO