Retrieve the content of a Memo field
Memo fields are a little bit tricky. The content of a memo field is not contained in the *.dbf table, but in the corresponding *.ftp file.
The behavior of a memo field is not so different from a blob/binary field field.
If you need to select/export into a cursor or a dbf table, the select syntax does not change, and FoxPro takes care of everything.
If you export to another type of file (xls, csv, etc...) you will need to wrap the name of the field you want to extract with the mline() function.
* mline syntax
mline(memo_field_name, line_number)
* select the first line of the field do_ref1
mline(do_ref1, 1)
* select the second line of the field do_ref1
mline(do_ref1, 2)