Follow

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)

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments